Viewing 15 posts - 61 through 75 (of 177 total)
avipenina (7/23/2008)
when i run this command FSUTIL FSINFO NTFSINFO L: i get this results 65536.
but when i run this command SELECT VOLUME,LIST PARTITION i get this results Offset = 32KB.why?
The...
July 23, 2008 at 6:52 am
You may want to consider RAID 10, instead of RAID 5 for your SQL volumes - RAID 5 is not a recommended configuration. Also, dont forget to format your volumes...
July 22, 2008 at 8:40 am
Taken all together, a good round up of the differences, but you all just ruined one of my favorite questions for DBA candidates - 'Describe the differences between Temp Tables...
July 17, 2008 at 10:04 pm
Not convinced on the usefulness of sparse columns...
I think this is the reference URL the answer page should have sent you to (I got a resource not found error when...
July 16, 2008 at 9:32 pm
Shouldn't be, as far as I'm aware. You may want to ping Idera directly on this.
July 11, 2008 at 1:44 pm
I dont believe its a SQL file - did you try right-clicking on the exe and inspecting the file properties? Look on the 'Version' tab for the Company, Product Name,...
July 11, 2008 at 1:33 pm
Apparently, you need SQL Client tools installed ... http://www.sqlservercentral.com/Forums/Topic206888-9-1.aspx.
We had DM at my last place, and it was an excellent tool, wish I could persuade my management to shell out...
July 11, 2008 at 1:27 pm
The scripting functionality was much improved in SP2 (almost as good as it was in 2000 EM :hehe: ), so make sure you have SP2 installed on your SSMS installation.
July 11, 2008 at 12:45 pm
gandalf97us (7/8/2008)
Basically, what I was getting at in my post was that it wasn't just spelling and grammar that needed the editing but the SQL scripts as well. Here...
July 8, 2008 at 2:53 pm
Defragmenting Indexes is a good idea, but it will actually make your current problem worse - Reindexing is a logged operation, and it will grow your LDF file.
You need to:
(1)...
July 4, 2008 at 9:11 am
Manoj (6/24/2008)
Is it possible for you take backup of Access DB and restore it into SQL 2005 server?
This is not possible, please check your advice before posting.
July 3, 2008 at 9:55 pm
Kalyan (7/3/2008)
... transaction log backup with truncate_only option
Of course, only use the TRUNCATE_ONLY option if you dont need to be able to recover the database.
:exclamation:TRUNCATE_ONLY will break your recovery...
July 3, 2008 at 9:45 pm
Shrinking the database daily is a very bad idea - you will end up with fragmented database files very quickly.
What backup schedules are you running: Full - how often,...
July 3, 2008 at 11:27 am
GSquared / Lynn, thanks for your insights.
So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours and implications of...
July 3, 2008 at 11:03 am
GSquared (7/2/2008)
Don't use table variables unless you absolutely have to. Even then, check your options with someone else.
Why do you say that? I'm not necessarily an advocate of table...
July 2, 2008 at 10:08 pm
Viewing 15 posts - 61 through 75 (of 177 total)