SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,905 reads
Glenn Berry
SQL Saturday #52 in Denver
Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held...
2010-09-17
636 reads
Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance
I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot...
2010-09-16
815 reads
Some Moderately Big Iron on x64
Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM....
2010-09-08
1,000 reads
Discount Code For SSWUG Ultimate Virtual Conference
If you are interested in watching some high quality SQL Server content from the comfort and convenience of your own...
2010-09-03
738 reads
Hardware Performance Research
I am trying to gather some information about some of the newer Intel and AMD processors as part of my...
2010-08-30
1,887 reads
How Old Are Your Database Statistics?
Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...
2010-08-30
10,963 reads
SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,197 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,711 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,109 reads
Blogs
Data Viz in Fabric Notebooks
Lots of people have created Power BI reports, using interactive data visualizations to explore...
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers