Windowed Aggregate functions

Aggregating Correlated Sub-Queries

Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:

RE: dynamic sql vs. clustered index scan

Or you could keep your static SQL but rather than make use of your charindex statement, which cannot use any indices, you can use a UDF that returns a table. For example, this UDF will take a comma separated list of integers as a string and returns a table (I think I got this from […]

Hardware Selection

I need some advice on how to set up the most optimal drive configuration for a new MS SQL Server machine. Which version of RAID would you choose?  Is it best to have 3 separate controllers attached to 3 separate sets of drives with one each reservered for Data, Indexes, and Transaction logs?  Or is there […]

RE: takes too long to view database property in EM

Is it every time? I've had this happen on occassion with some servers or workstations. Have you traced to see where the slwodown might be?

Copying only the structure of a DB

I have a populated SQL 2000 database...and I'd like to make 2 empty copies of it....Basically, we want to populate 2 new db's with different data....but with the same structure as the original populated db.What would be the best way to do this? Thanks!

RE: Timestamp on threads

Self-referentially short for PHP: Hypertext Preprocessor, an open source, server-side, HTML embedded scripting language used to create dynamic Web pages. In an HTML document, PHP script (similar syntax to that of Perl or C ) is enclosed within special PHP tags. Because PHP is embedded within tags, the author can jump between HTML and PHP […]

RE: drop column with default

Thanks so much !! I can extract exactly what I need from that. Doug

RE: "I renamed the file and it does not work"

One of our customers stated he didn't need backups copied to a safe place. When he tested his backup-power-system there was this litle problem where in stead of 220V the server got a slam of 360V. Ofcourse there was some damage. Fortunatly we had a set of recent images we could restore. We needed +- […]

RE: Differences b/w 7 and 2000

Hi Kathi - this is exactly what I was looking for, thanks! Not sure how I missed it in BOL