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...

They probably asked around and realized that a lot of folks, like me, never used the object search. I played with it a few times back in 2001, then...

I recently lead the movement of the databases for our 10TB application from one datacenter to another, and we used the same process mentioned above:

- Ship backup tapes to...

Replied too quick 😛

Ouch! Sorry to hear it. We've had that happen twice with LiteSpeed x64 edition on SQL 2005 enterprise.

The only solution was to restart the instance. The hung...

First, partitions are open-ended. When using RANGE RIGHT, the first partition holds all data less than the first value listed. In this case, the first partition is for...

Check BOL for the STATS_DATE ( table_id , index_id ) function.

-Eddie

What that often means coming out of the mouths of developers is that they want to use some code-generators and write zero T-SQL.

Data access will be either all...

You have a couple options to take an existing non-partitioned table and convert it to an partitioned table.

Hint: see BOL, Look for: "partitioned tables [SQL Server], modifying" in the index....