SharePoint 2010 And SQL Server 2008 R2
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
2009-10-23
1,608 reads
Blogs
Transparency and PASS
I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a...
2009-10-22
1,151 reads
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
2009-10-21
1,724 reads
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-20
2,666 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-19
3,076 reads
Work on a Strength or Weakness?
When deciding what to learn, there's a binary decision. Will you focus on a strength or a weakness? I think many people focus mostly on their strengths because they have a goal of really standing out in something. They perhaps want to avoid being..
2009-10-16
1,577 reads
Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I had set up a simple demo of a sparse column set and happened to look at the execution plan, was interested to see that the Compute Scalar was backed by ConvertSVtoXML. This was on a select from a table with one row, and then, being a little more curious, updated it with an xml fragment I saw a call to ConvertXMLtoResv. I’d venture that those serve to convert back/forth from XML storage.
2009-10-15
1,219 reads
Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-14
1,825 reads
Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-13
6,074 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers