SQL Server 2008 Diagnostic Information Queries (Late November 2009)
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008. Running these queries will give you...
2009-11-24
2,429 reads
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008. Running these queries will give you...
2009-11-24
2,429 reads
PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the...
2009-11-23
980 reads
If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it...
2009-11-23
503 reads
During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in...
2009-11-19
1,013 reads
Back before I grew up and became a DBA, I used to be a developer. This seems to be a...
2009-11-18
481 reads
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 1. You can go here to request the...
2009-11-17
527 reads
We have been using SQL Server 2008 Integrated Full Text Search (iFTS) in Production at NewsGator for a little over...
2009-11-17
946 reads
Kimberly Trippposted today about the SQL Server MVP Deep Dives book signing event at PASS on November 4. The PASS...
2009-11-17
641 reads
If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you...
2009-11-14
1,431 reads
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-13
1,312 reads
Want to blend your love of marketing with the power of data? Becoming a...
I live for questions and this was an interesting one. Can you see Table...
By Steve Jones
I’m not looking for a job, but I ran across an article about using...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Comments posted to this topic are about the item Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers