Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that...
2011-03-01
600 reads
Jason Brimhall
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able...
2011-03-01
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way...
2011-02-28
3,512 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command?...
2011-02-28
1 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed?...
2011-02-25
1,973 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed? On occasion you may want to know what the...
2011-02-25
1 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you...
2011-02-22
442 reads
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
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You...
2011-02-17
476 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You can read about that here. Of all of the...
2011-02-17
Blogs
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers