Viewing 15 posts - 1,816 through 1,830 (of 2,496 total)
Dio you have 8.3 filename creation disabled? SQL Server 2005 install requires that 8.3 filename creation is switched on, as the path names used to create the service entries...
January 24, 2008 at 5:41 am
SQL Server components are split across 2 install folders. The Server folder on the DVD (CD1 on CD media) contains only the server components. The Tools folder on...
January 24, 2008 at 4:02 am
Like someone else just said, SQL Server 2008 won't support DTS.
SQL Server 2008 will support the same DTS Designer component as SQL Server 2005. There are some blog postings...
January 22, 2008 at 2:43 am
Windows compressed folders do not compress files over 2GB. What may be happening is that as you write the log backup, Windows is compressing the data. When the...
January 18, 2008 at 2:41 am
I think SSAS needs enough memory to hold all the dimemsions of all the cubes. Therefore the more cubes you have, the more memory you need.
January 18, 2008 at 2:29 am
Steve,
Sounds reasonable. Hopefully you can update the what is displayed on old postings to show the new name the person uses.
However, I think you should stay as 'Steve...
January 17, 2008 at 3:55 am
The critical time for synchronising backups is not the start time, not the end time, but the time in the middle when the actual full backup ends and the built-in...
January 17, 2008 at 3:50 am
As Steve said, some blocking is normal.
After you install SQL 2000 SP4, you may well see blocking happening when nothing was reported in SP3. The blocking is not anything...
January 16, 2008 at 3:07 am
We make extensive use of free text searching where I work. John is right, you need to construct a dynamic SQL query using the data supplied by the user....
January 16, 2008 at 2:58 am
As people have said, SSIS is the favoured tool for developing DTS-like functionality on SQL 2005 and onwards.
However, you can still use all the SQL 2000 functionality in SQL 2005,...
January 16, 2008 at 2:51 am
You simply cannot synchronise backups in this way. All it needs is a few milliseconds difference in the backup completion time and you have committed data on machine A...
January 16, 2008 at 2:42 am
If your main server is 64-bit and your DR server is 32-bit, then you should test that all your application code works in both environments.
Also test that the...
January 16, 2008 at 2:33 am
I gave the limit of 1 MB for the type of reasons given by Dave and Grant.
On small tables the optimiser will often find it is cheaper to...
January 11, 2008 at 2:33 am
Lots of posts in thi sforum, but no-one has asked Arun why he wants to know if a #temp table exists already.
There are very few situations where this information is...
January 10, 2008 at 5:03 am
Why should the table size chage after you move from text to varchar? The total data is the same.
What has happened, as Jeff says, you now normally have 1...
January 10, 2008 at 4:34 am
Viewing 15 posts - 1,816 through 1,830 (of 2,496 total)