A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
413 reads
Blog Posts
Jacksonville SQLSaturday less than a month away!
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based...
2008-04-05
532 reads
SQL Server Forensics Book
I logged into Safari today to download some chapters I want to be able to review when I'm offline. I...
2008-04-05
1,262 reads
Changing Dynamics on a Project Team
MVP Andy Leonard has written a nice post about how the dynamics changed on a project team. Most of it...
2008-04-04
593 reads
Configuring SPN for SQL Server Browser service
Going through the Microsoft KnowledgeBase updates, I saw this one:
An SPN for the SQL Server Browser service is required when...
2008-04-04
2,489 reads
Installing 5.0.51a MySQL Community Edition on Windows Vista
I'm still working on getting all of my tools and apps onto my new laptop, which is running Vista Ultimate....
2008-04-04
2,524 reads
Cheap But Good KVM Switch
I needed a KVM (keyboard-video-mouse) switch for home to let me switch between two machines, found the Trendnet 2 Port...
2008-04-03
324 reads
MVP Award
Yesterday I found out that I am a new SQL Server MVP. I still have the feeling that I am...
2008-04-02
376 reads
Other Thoughts on Brand Building
Just a link today, but a good one on Building a Powerful Reputation that is a nice follow up to my...
2008-04-02
459 reads
If You Like Books - Look at LibraryThing
I've been following their blog for a while at LibraryThing and so far it looks interesting. The basic premise is...
2008-04-01
258 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers