Viewing 15 posts - 5,656 through 5,670 (of 18,926 total)
any 3rd party application that may be compressive the drive and preventing the drive from getting filled up beyond x%?
Maybe norton AV or something similar getting in the way?
May 30, 2011 at 11:34 am
How big is the database once restored?
You could possibly have a 200 GB backup file but with a 1 TB db once fully restored, that could explain this.
May 30, 2011 at 11:15 am
SET @sql = 'ALTER TABLE [' + @Table_Name + '] DROP [' + @default + ']'
May 30, 2011 at 11:07 am
May 30, 2011 at 10:55 am
Are you doing this in SSRS? If so this is a really easy pivot in there.
May 30, 2011 at 10:52 am
The first check means add this fk and enable it (you could add it but disabled using nocheck).
The 2nd alter means to go in and validate all the data right...
May 30, 2011 at 10:31 am
Set auto_close and auto_shrink to OFF.
Rebuild all indexes and update all stats at your next maintenance window.
May 30, 2011 at 9:52 am
Have you checked the sans to make sure there's nothing wrong there?
1 db "might" be a fluke, but not 2-3!
May 30, 2011 at 8:58 am
shyamhr (5/30/2011)
Thanks a lot Victor ... Cheers 🙂
Seriously why do you need dynamic sql here??? I really don't see the need for it!
May 30, 2011 at 8:20 am
GilaMonster (5/30/2011)
SUPER SQL STAR (5/30/2011)
EXEC sp_resetstatus 'yourDBname';ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
No, no, NO!
That is...
May 30, 2011 at 8:12 am
Like I said I'm not a FTS guru but I know enough to have a real good guess that FTS can't really fare any better than like 'S%'
What's the full...
May 30, 2011 at 7:55 am
GilaMonster (5/30/2011)
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
+1 Million
May 30, 2011 at 7:47 am
Why not just do select * FROM ... WHERE Column = @Variable
You won't need quotes for that.
Moreover you won't need dynamic sql!
May 30, 2011 at 7:45 am
Any reason why you have to do it with FTS?
WHERE Name LIKE 'S%' sounds like a reasonable alternative to me!
And no I don't know how to do that in FTS!
May 30, 2011 at 7:22 am
Viewing 15 posts - 5,656 through 5,670 (of 18,926 total)