A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-11
1,791 reads
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-11
1,791 reads
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-08
1,487 reads
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-15
1,831 reads
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-03-02
2,690 reads
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
2011-02-23
2,324 reads
On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the...
2011-02-23
2,996 reads
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-15
1,312 reads
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-10
2,126 reads
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...
2011-02-09
4,981 reads
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-02-04
2,138 reads
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
When Covid took out the PASS organization, I had someone say to me, “Well,...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL...
Comments posted to this topic are about the item Smile and Wave Boys
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint)) , BIT_COUNT (CAST (-1 as bigint))See possible answers