Viewing 15 posts - 496 through 510 (of 700 total)
I don't think the dates are posted anywhere. There's a page that lists projected release dates for upcoming courses on the MCT private site. Dates are not guaranteed; courses may...
April 17, 2007 at 2:09 pm
I'd like to hear more about the hiccups, too. We are eyeing Polyserve as a replacement for Microsoft Clustering Services. We have no problem with sprawl, it's a pure HA...
April 17, 2007 at 12:52 pm
A couple things:
1. Always store your PerfMon logs in binary (.blg) format instead of .csv format. It's more efficient, and loads into Profiler just as csv files do.
2. As Amit...
April 15, 2007 at 9:15 pm
Use the MAXDOP (Max. Degree Of Parallelism) query hint option:
SELECT
col1, col2
FROM dbo
April 11, 2007 at 4:02 pm
SUM
(CASE WHEN Direction = 'INBOUND' THEN 1 ELSE...
March 26, 2007 at 12:21 pm
Check Books Online: "Specifying AFTER is the same as specifying FOR"
March 14, 2007 at 7:56 pm
You are correct in that SQL Server has no information about where the files reside, be it single disk, RAID, etc.
As for the question:
>is it possible to say which drive...
March 13, 2007 at 9:40 pm
When you create a unique constraint, a unique index is created to enforce it.
-Eddie
March 12, 2007 at 4:19 pm
Just echoing other comments opposed to hard-coding an objects type in the object's name ("t", "tbl", "v", "viw", "int" - prefix or suffix): it is a blueprint for disaster. As databases and...
March 8, 2007 at 1:09 am
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcreateparam.asp
Set parameter = command.CreateParameter (Name, Type, Direction, Size, Value)
You are setting your parameter lengths to 50.
SET objParam1 = objData2.CreateParameter("@ObjID",129, 1, 50)
Set the length value to 75,...
March 4, 2007 at 9:42 am
I split all of our full Litespeed backups into 4 files, this includes a database approaching 3TB. I send different files to different SANs through multiple HBAs for better throughput.
If...
February 21, 2007 at 11:14 am
You can use the dynamic management view sys.dm_exec_query_stats to pull out execution statistics. I took some code I use to examine the query plans of problem spids (via sys.dm_exec_query_plan), and...
February 16, 2007 at 2:33 pm
Betty,
The value 6447.53 is effectively a prime number for two decimal places. The true average of the 7 values used to produce that value cannot be expressed with only 2...
February 16, 2007 at 1:32 pm
I'm guessing SQL Server 2000 here.... if you were using SQL 2005 you'd build the dll as a .net assembly, and just import the assembly with EXTERNAL access and...
February 15, 2007 at 2:45 pm
If you are concerned about precision and accuracy, then stay away from the float and real datatypes, which only store approximate values.
From BOL: "Because of the approximate nature of the...
February 15, 2007 at 2:31 pm
Viewing 15 posts - 496 through 510 (of 700 total)