Hi Sqlers,
Paramenter @Action, which will be Enable or disable to perform the requested action on triggers accross all tables in your sql db, this works on tables with schemas as well.
2010-04-19 (first published: 2010-04-14)
1,120 reads
SQL 2000 OnlyThis script will create a stored procedure and a table in the master database. Simply run the stored procedure and supply a database name as a parameter. It will do the following:1. Gather/Log DBCC SHOWCONTIG statistics (pre defrag)2. Defragment all user indexes in the database3. Gather/Log DBCC SHOWCONTIG statistics (post defrag)4. DBCC DBREINDEX […]
2010-04-19 (first published: 2003-03-19)
2,217 reads
2010-04-15 (first published: 2010-03-28)
13,263 reads
The Stored Procedure sp_whocpu shows cpu_delta - a metric I introduced to define the real time CPU activity
2010-04-14 (first published: 2010-03-28)
3,533 reads
The Stored Procedure sp_whoio shows DiskIO_delta - a metric I introduced to define the real time I/O activity
2010-04-12 (first published: 2010-03-28)
3,825 reads
This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
2010-04-09 (first published: 2010-03-09)
2,149 reads
2010-04-06 (first published: 2010-04-01)
3,930 reads
2010-04-01 (first published: 2010-03-31)
4,371 reads
With this view you can obtain last failed job steps without using visual interface.
2010-03-30 (first published: 2010-03-19)
2,350 reads
2010-03-29 (first published: 2010-03-24)
1,827 reads
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
I am using the following script to import data from a json file. This...
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Which of these inputs is the smaller input to a hash join?
See possible answers