Publications

Dec 4 2008

Volunteerism and PASS

Most of you out there in the SQL community are aware that this week in the annual U.S. PASS Summit This year brings us back to Seattle and so far weather has cooperated. However, weather has little bearing when we are at a technical summit such as PASS. PASS is not just a technical summit – it is a user community that happens to present a technical summit, both in the U.S. and in Europe. That is what differentiates us from the SQLConnections, TechEds, and DevTeaches of the world. It also means that PASS relies heavily on its reserve of volunteers …

By Timothy • PASS, Syndicated •

Dec 1 2008

SQLServerPedia

The official launch of the SQLServerPedia wiki is about to take place. This will happen during the PASS Summit in Seattle the week of November 16th. However there is no better time than the present to spread the word on this new resource for Microsoft SQL Server information and problem-resolution.

By Timothy • SQLServerPedia, Syndicated •

Dec 1 2008

Problems With Installing SQL Server 2008 Management Studio Not Necessarily The Fault of SQL 2005 Express Tools

Problems with installing SQL Server 2008 Management Studio? Maybe it’s not SQL 2005 Express Tools as you’re being told by the installer.

By Timothy • Syndicated, Tips and Tricks •

Dec 1 2008

Using Dynamic SQL in Cursor Versus sp_MSforeachdb

sp_MSforeachdb yeilds unexpected results when you exclude databases compared to cursors.

By Timothy • Syndicated, Tips and Tricks •

Dec 1 2008

Table Space Calculation, Redux

I’ve been asked if there was a SQL 2000 version of the Table Space Calculation code I posted the other day. The answer is yes. It only required that I change the @Results table variable to a temp table, #Results. This will work on SQL 2000, 2005 and 2008. While I was at it, I modified the code to report back results in Mb (who cares for Kb anyhow?)

By Timothy • Syndicated, Tips and Tricks •

Dec 1 2008

Determine Space Consumption At The Table Level

Yesterday, I was asked about how much space certain tables were consuming in one of the databases I support. I created the following query to provide that information.

By Timothy • Syndicated, Tips and Tricks •

Publications

Volunteerism and PASS

SQLServerPedia

Problems With Installing SQL Server 2008 Management Studio Not Necessarily The Fault of SQL 2005 Express Tools

Using Dynamic SQL in Cursor Versus sp_MSforeachdb

Table Space Calculation, Redux

Determine Space Consumption At The Table Level

Like My Stuff? Subscribe:

SQLAgentMan Twitter Feed

Publications

Volunteerism and PASS

SQLServerPedia

Problems With Installing SQL Server 2008 Management Studio Not Necessarily The Fault of SQL 2005 Express Tools

Using Dynamic SQL in Cursor Versus sp_MSforeachdb

Table Space Calculation, Redux

Determine Space Consumption At The Table Level

Like My Stuff? Subscribe:

SQLAgentMan Twitter Feed

Tags