Extract CLR Assemblies from SQL Server
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...
2012-03-02
3,156 reads
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to...
2012-03-02
3,156 reads
I’ve run into a few situations that required examining the existing CLR assemblies on a server. Whether I needed to do a comparison between two versions to make sure...
2012-03-02
410 reads
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,412 reads
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
42 reads
Severalprofessionalshaveposted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to...
2012-02-16
1,134 reads
Several professionals have posted about checking whether or not your processors are running at full speed by using CPU-Z. Some recommendations are to check your servers every couple of...
2012-02-16
41 reads
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to...
2011-11-09
4,477 reads
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
741 reads
A few weeks ago one of our clustered server nodes blue-screened and when it came back on SQL refused to start. I started digging in and this is what...
2011-11-09
9 reads
My favorite and most used feature of the SSMS Tools Pack is the query history. This feature has saved me...
2011-10-06
1,137 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;