I was asked by a developer at work the other day why SQL Server does not have the create or replace syntax. I started thinking and there were some advantages and one big disadvantage First the advantages   AdvantageWhen scripting out a database you don’t have to generate if exists.....drop statements When modifying an object from a file ...

So, I am finally back from hibernation - and I hope it lasts! It all started when I got an email today from Joe Healy. For those of you who dont know Joe, he is my favorite .NET developer evangalist from FL. You can find out more about Joe the vibrant FL community from his blog. Now, as you will find out through my blogs, I am no .NET ...

How come I've missed this? I don't know, but I'm writing this blog post so to bookmark this site. You'll find a handful of scripts, mainly using Dynamic Management Views and Functions, to monitor various aspects of SQL Server. http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true

Short answer: no.  This question came up today in the MCT discussion group. My gut instinct said no, but I wanted to test it to be certain. But first a brief background: You can rebuild an index using DBCC DBREINDEX or in 2005 (and now preferred) ALTER INDEX ... REBUILD. Rebuilding an index internally creates a new index and when that has ...

If you have been wondering where Notification Services (NS) is in the prior CTPs of SQL Server 2008, you now have the answer. NS will not be carried forward to SQL Server 2008. Here's a quote from July CTP readme: ''SQL Server Notification Services will not be included as a component of SQL Server 2008, but will continue to be supported as part ...

No. Let me elaborate a bit. You might have seen and read about the feb 27 launch of SQL Server 2008. Now, in MS lingua, ''launch'' is not the same as ''ship'' or ''release to manufacturing'' (RTM). So, the Feb 27 event is a marketing and awareness event. RTM will be later.

I'm sure that some of you have been annoyed when searching or using the index and found a hit, thinking it looks strange, only to realize that you are looking at a ''Compact Edition'' topic. This has happened to me more than once. We just had a discussion about this in the MVP group and Umachandar Jayachandran (aka UC) have use this great ...

Obviously, were talking about multi-statement functions, since in-line functions are just views in the end.  My gut feeling for this is ''yes'', but I wanted to be absolutely certain. So here goes: Create a function in Adventureworks Use that function in a SELECT statement Check if a plan exists in the plan cache for above USE ...

As you probably know, there's a trace running by default in SQL Server 2005. The directory for the trace file is the SQL Server log directory, and you can turn off and on this trace with sp_configure. But how do we find out what events and columns are traced to this? We use a trace function ande some trace catalog views: The function ...