Good point, David. I remember another thread from a few days ago where someone said something to the same effect.

Reporting Services is just a web application (that runs on IIS) with two SQL Server databases to store its internal information and to use as temp space when compiling reports....

April fools?

You can install another instance of Standard Edition on the same physical server (not in a cluster - that requires Enterprise Edition). With Standard Edition you have to pay for...

The only thing I know of that you can do is SET DEADLOCK_PRIORITY. This only controls which spids would get killed if a deadlock occurs (you're basically designating this SP...

Yep, it's definitely how long and how loudly we complain.

One script to accomplish this is in the scripts section under something like orphan users. Here's a copy:

declare @usrname varchar(100), @command varchar(100)

declare Crs insensitive cursor for

select name as UserName from...

regarding the thread comment, SQL Server will spawn a seperate thread for each file (say you have a filegroup of three files, SQL Server will spawn three threads to read from...

As far as I know, there is only one version of reporting services. You do not have to purchase a seperate license for Reporting Services unless you want to install...

For more information, check out the MCP FAQ: http://www.microsoft.com/learning/highlights/announcefaq.asp.

(excerpt)

Historically, the MCP program has required certified individuals to meet certification upgrade requirements to remain certified. This program requirement...

I agree with you, sppwiz. The only thing I'm not sure about is the expiration of certs. When MS announced 'retiring' NT4, there was an uproar. IIRC, they implemented a policy...

using dbo in this context identifies the table owner. I.E. if you had two tables with the name table1 in your database, one owned by dbo and one owned by...

I haven't had any problems moving files of this size over a network (it just takes a lot of time), but that really depends on the quality of your LAN/WAN,...

Varchar doesn't pad the entries with extra data like spaces. Char datatypes do. You shouldn't have a problem with 'unused' space with varchar columns.

Search for "Using char and varchar...

Better example, using your servername:

Default Instance     -     MySQLServer

Named Instance      -     MySQLServer\instance1 (files will be under the C:\Program files\...\MySQLServer$instance1 directory)