Darth do you have a Calendar table?

for me, business days, well, depend on our specific business.

for example, the quarter for today's date is from 10/1/2012 to 12/31/2012.

there are 92...

on my dev machine I have the last 4 versions of SQL installed.,and i have a port layout scheme to make it obvious to myself,

my default instance is 2005 listening...

in 2005, there's the surface area configuration utility to add yourself:

in 2008, you need to start the service in single user mode, and add yourself.

http://www.bradg.co.za/?p=51

i think it's...

that package adds the ACE drivers, which are not the same as the OleDB.

it's just like adding the drivers for MYSQL, SQLite or any of the many ODBC drivers for...

Sanjay openrowset does not allow variables...it must be a static string inside single quotes. Replace @image with 'c:/filename'

You could build an openrowset as a string and use dynamic sql instead

instead of dropping and recreating, it would be much faster and easier to generate code to simply rename the existing constraints.

this is what i would do:

/*

EXEC sp_rename 'DF__SFHEAD__MSLOAN__51278362','DF__SFHEAD_MSLOAN'

EXEC sp_rename 'DF__SFHEAD__URUSEAMT__2D8A0CC1','DF__SFHEAD_URUSEAMT'

EXEC...

ok clue me in, because i'm not seeing it...

what difference does it make on # of logical cores?

why not calculate, say 7/8ths of the total available memory for the SQL...

here's an example that kind of shows what we are talking about...you have to select from all possible values, and join that to what was sold.

run this and take a...

Unless you've already setup a...

Received an pm asking for more details on the programming portion of this, as CLR can be a bit scary the first time around.

hopefully, this can get someone started, but...

these two queries seem to return all the objects and all the assemblies:

EXEC sp_MSforeachdb 'SELECT ''?'' As DBName,

...

oh yeah!!!

I'd do exactly what Sean is recommending...I'd have a service slam the web site and store the results in a table, all outside of TSQL.

Now, having said that, just to...

here's a TSQL method, which generates the actual REPLACE statements you would want to use to remove the css style assignment, if it exists.

Notice how i'm generating a lsit of...