That price looks like a one-CPU Enterprise+SA processor license. If you think you may ever upgrade to SQL 2008, pick up SA.

We are only going to need about 25...

9:1:4505200

database:file:page

Database 9 (select * from sys.databases where database_id = 9)

File 1 (select * from master.sys.master_files where database_id = 9 and file_id = 1)

Page 4505200

To see what object (table) uses that...

We picked up Red Gate's SQL MultiScript tool for the data team (actually, we got the whole toolbelt, but this was a big reason for it), and cleaning out logins...

Log-ship the database to the new LUN:

1. Restore a recent backup on the server as a database with a different name.

2. Restore all log backups.

3. Add a step to your...

Or, better yet, just write your backup job to walk through sys.databases, and backup every online user database.

In SQL Server Management Studio:

Tools -> Options -> Environment -> Keyboard

-Eddie

Why the requirement to to make connection property changes so easily? Once the instance is virtualized, the connection string doesn't change.

If your virtual server name is VirtServ1, then the...

I would like know where you read that log shipping is being phased out, because either somebody needs to be corrected in a big way, or you missed the point...

The LiteSpeed Extraction Utility (extractor.exe) is part of the LiteSpeed install. Usage is covered in the LiteSpeed help file.

-Eddie

Roy,

Why would you go through the trouble of the UNION ALL view? Does OBJECT_NAME() not work for you?

-Eddie

OBJECT_NAME() takes two parameters, the second being an optional database id. Both values are available in sys.dm_exec_sql_text.

For example:

SELECT r.session_id, r.wait_type, r.wait_time, r.reads, r.writes, r.logical_reads, r.cpu_time,

...

The problem is that by using a variable that way, the result is the same as if your query were:

[font="Courier New"]SELECT e.C1, e.C2, e.C3, e.C4, ROW_NUMBER() OVER(ORDER BY 'C1') as...

The multiplexing topic you reference is the key point. You are licensing the users accessing the data, not the software accessing the server. If users are using Business...

CALs are not server-specific. One CAL allows a single user to connect to any number of SQL Servers on the same physical network of the same edition as the...

When you create a database, all of the system objects go into the filegroups where they reside in the model database. Unless you've changed that, that means they all...