Sladescross's Blog

Blogging about Sharepoint related stuff

Index Details April 22, 2014

Filed under: DESC,Details,Index,Sort Order,SQL — sladescross @ 1:54 pm

http://www.toadworld.com/platforms/sql-server/w/wiki/9631.find-information-about-indexes.aspx

SELECT
TableName = t.name,
IndexName = ind.name,
IndexId = ind.index_id,
ColumnId = ic.index_column_id,
ColumnName = col.name,
ind.*,
ic.*,
col.*
FROM
sys.indexes ind
INNER JOIN
sys.index_columns ic ON ind.object_id = ic.object_id and ind.index_id = ic.index_id
INNER JOIN
sys.columns col ON ic.object_id = col.object_id and ic.column_id = col.column_id
INNER JOIN
sys.tables t ON ind.object_id = t.object_id
WHERE
t.name=’stgTest1′

 

SQL Agent and SSIS Troubleshooting

Filed under: Package,SQL Agent,SSIS,Troubleshooting — sladescross @ 9:34 am

SELECT TOP 1000 [instance_id]
,[job_id]
,[step_id]
,[step_name]
,[sql_message_id]
,[sql_severity]
,[message]
,[run_status]
,[run_date]
,[run_time]
,[run_duration]
,[operator_id_emailed]
,[operator_id_netsent]
,[operator_id_paged]
,[retries_attempted]
,[server]
FROM [msdb].[dbo].[sysjobhistory]
WHERE Message Like ‘%the package execution failed%’
ORDER BY [run_date] DESC

 

windows – No permission to access SQL server perfmon counters – Server Fault April 20, 2014

Filed under: Uncategorized — sladescross @ 9:25 am

http://serverfault.com/questions/80463/no-permission-to-access-sql-server-perfmon-counters

 

SSIS: Understanding BufferTempStoragePath | Intelligent SQL

Filed under: Uncategorized — sladescross @ 9:10 am

http://intelligentsql.wordpress.com/2014/01/07/ssis-understanding-buffertempstoragepath/

 

SSIS Container Hierarchy April 17, 2014

Filed under: Container,Container Hierarchy,Hierarchy,SSIS — sladescross @ 1:33 pm

http://consultingblogs.emc.com/jamiethomson/archive/2004/12/13/445.aspx

 

SUS and Data Feeds April 16, 2014

Filed under: Data Feeds,NHS,SUS — sladescross @ 3:59 pm

http://www.hscic.gov.uk/susguidance#cmsanchorhow_do_I_extract_data_from_SUS

 

OnPipelineRowsSent April 15, 2014

Filed under: Pipeline,Rows,SSIS — sladescross @ 4:29 pm

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/08/SSIS_3A00_-OnPipelineRowsSent.aspx

 

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers