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
Getting More Hardware Information from SQL Server Denali DMV Queries
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
A Small Collection of SQL Azure Queries
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
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
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
Is CPU-Z Risky To Run on a Production Server?
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
New Version of CPU-Z (1.57) has Been Released
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
Windows Instant File Initialization and SQL Server
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
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
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
Five DMV Queries That Will Make You a Superhero in 2011!
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 Support Policies for Windows Server and SQL Server
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
Blogs
Daily Coping 23 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Getting Up and Running with Dapr
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
Data Platform products for Microsoft gaps
By James Serra
Microsoft has a ton of data platform-related products, but there are certain areas where...
Forums
output of stored procedure to text and email text
i have a stored procedure which outputs data from various table query like below....
needing help casting varchar to decimal
I'm needing to convert some varchar figures to decimal for sums, but can't quite...
Colum Header adding a 1 to the text when downloading?
Hi, I come across this once in a while, I have a column header...
Ask SSC