Can You Dig It? – Missing Indexes
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
2010-12-14
2,764 reads
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
2010-12-14
2,764 reads
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
Don’t forget, PASSMN meeting is today. As I’ve said before,...
2010-12-14
688 reads
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,482 reads
Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection)...
2010-12-14
17,903 reads
One thing I have gotten wrong before, or not elaborated on during a past presentation on mirroring, although Roman Rehak mentioned...
2010-12-14
3,036 reads
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
608 reads
I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse...
2010-12-14
658 reads
One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working...
2010-12-14
1,265 reads
Business Requirements
We have made it yet another month and to yet another episode in the continuing saga known as TSQL...
2010-12-14
651 reads
I think a common area that is easily overlooked when it comes to requirements and interpretation of requirements is report creation. A common problem is that there are no...
2010-12-14
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
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