Browse by Tags

All Tags » SQL Server (RSS)
Tuesday, June 03, 2008 12:50 PM

TechEd 2008 Keynote Summary

Here are the highlights from the TechEd 2008 Keynote (as seen from afar by watching the TechEd 2008 Keynote and reading posts and press): Via Microsoft PressPass , here are the key announcements (with my notes): Internet Explorer 8 beta 2 will be available...
Posted by Jon Galloway | 11 comment(s)
Filed under: , , , , ,
Sunday, January 27, 2008 1:20 AM

Adding simple trigger-based auditing to your SQL Server database

How do you track changes to data in your database? There are a variety of supported auditing methods for SQL Server, including comprehensive C2 security auditing , but what do you do if you're solving a business rather than a security problem, and you...
Posted by Jon Galloway | 68 comment(s)
Filed under: ,
Wednesday, July 18, 2007 11:56 PM

The real reason SELECT * queries are bad: index coverage

Are SELECT * queries bad? Sure, everyone know that. But, why? It's returning too much data, right? That's the common answer, but I don't think it's the right one. If you're working with a reasonably normalized database, the actual network traffic difference...
Posted by Jon Galloway | 20 comment(s)
Filed under: ,
Thursday, July 12, 2007 10:50 PM

[T-SQL] Getting distinct, current entries from tables with timestamp / datetime fields

It's relatively easy to store data with a time dimension, but querying it is another matter. If you select from a temporal tables (one which includes historical information indicated by a timestamp or datetime column) based on your ID, you'll get a lot...
Posted by Jon Galloway | 12 comment(s)
Filed under: ,
Thursday, June 21, 2007 12:09 AM

[SQL Server Analysis Services] - "Errors in the metadata manager" when restoring a backup

I had trouble restoring a SQL Server 2005 Analysis Services backup today due to "Errors in the metadata manager" messages: The ddl2:MemberKeysUnique element at line 243, column 28420 (namespace http://schemas.microsoft.com/analysisservices/2003/engine...
Posted by Jon Galloway | 2 comment(s)
Filed under:
Thursday, April 26, 2007 1:23 AM

SQL Puzzle #2 - Paging through a table with GO 10

I just wrote about using GO 10 to execute a T-SQL batch 10 times in SQL Server Management Studio . Could you use it to page through data? The challenge : Write an ad-hoc query which queries the AdventureWorks Production.Product table 10 times using GO...
Posted by Jon Galloway | 2 comment(s)
Filed under:
Wednesday, April 25, 2007 11:41 PM

[SQL] Using 'GO 100' to execute a batch 100 times

The GO statement is used by SQL Server as a batch terminator. It's recognized by by tools which run scripts like SSMS, SMO, and SQLCMD, but it's not technically T-SQL. SQL Server 2005 added a new little trick to the GO command which lets you specify a...
Posted by Jon Galloway | 4 comment(s)
Filed under:
Saturday, February 24, 2007 7:09 PM

[SQL] Force the protocol (TCP, Named Pipes, etc.) in your connection string

Barry Dorrans recently mentioned that you can force the database connection protocol by specifying np: or tcp: before the server name in your connection string . I've jumped through some hoops before using localhost to target tcp and (local) to target...
Posted by Jon Galloway | 8 comment(s)
Filed under: , ,
Friday, February 16, 2007 1:01 AM

Passing lists to SQL Server 2005 with XML Parameters

Overview SQL Server 2005's XML capabilities make it a easier to pass lists to SQL Server procedures. Background I recently needed to write a stored procedure which took a list of ID's as a parameter. That's one of those things that seems like...
Posted by Jon Galloway | 51 comment(s)
Filed under: ,
Sunday, December 31, 2006 3:53 PM

sysobjects, sys.objects... what about INFORMATION_SCHEMA?

SQL Server Management Objects ( SMO ) is one of the coolest parts of SQL Server 2005, in my opinion. I've written about SMO before , and used it extensively in writing Data Dictionary Creator . In a nutshell, SMO is a collection of objects that are...
Posted by Jon Galloway | 4 comment(s)
Filed under: ,
More Posts Next page »