February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you may know, I have moved from Vegas back to...
2011-02-22
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you may know, I have moved from Vegas back to...
2011-02-22
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek...
2011-02-22
802 reads
One character. That’s all it takes; just one character in a Transact-SQL query can make the difference between an index seek and an index scan. Transact-SQL is easy to learn....
2011-02-22
1 reads
My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...
2011-02-22
943 reads
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the...
2011-02-22
926 reads
We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the Hampton Inn right around the corner from the SQL...
2011-02-22
2 reads
As an old school DBA and always having cheap frugal employers, I have rolled my own management and monitoring solutions....
2011-02-22
560 reads
Sonny Bryans Smokehouse Bbq would make an interesting classroom
Today was the first day of my first SQLskills event. The event...
2011-02-22
429 reads
I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last...
2011-02-22
1,357 reads
Andy Warren posted a question the other day (well, issued a challenge actually), “What Should PASS Be?” I’ll let you...
2011-02-22
710 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers