Viewing 15 posts - 496 through 510 (of 708 total)
Also note that each user license is per user, not per connected user. If you have 800 separate users, but only 10 of them connected at any time, then you...
June 26, 2007 at 1:30 pm
Around here we refer to NeverFail as 'NeverWork' or 'AlwaysFail'; we ran the Exchange version for a while and it never worked.
June 26, 2007 at 1:18 pm
Note that in SQL 2005, that is no longer the case. If you're counting on that in existing 2000 implementations, you've got some refactoring to do before an upgrade.
-Eddie
June 1, 2007 at 1:41 pm
Call the vendor, tell them their passwords suck, demand either refund or secure software.
-Eddie
May 18, 2007 at 9:37 am
You will need to request the welcome kits (one for MCTS and one for MCITP-DBA) from the MCP site.
Note: If your Passport/Live ID is not set up with permissions to...
May 10, 2007 at 2:34 pm
Do not take your Red Bull... you are not allowed to go to the bathroom during the test. (I took most of the SQL 2005 exams while they were still...
May 8, 2007 at 9:32 pm
Are the original data files still in place from before the reinstall? (if you took the installation defaults, then look in c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data, or search your computer for...
April 18, 2007 at 12:43 am
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
Viewing 15 posts - 496 through 510 (of 708 total)