Viewing 15 posts - 35,281 through 35,295 (of 49,552 total)
Lennart Gerdvall (12/15/2009)
Anyone that disagrees?
Absolutely, 100% disagree. Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive...
December 15, 2009 at 8:02 am
Partitioning would make that a piece of cake. Since it's not an option, try one table per day, each day drop the oldest, create a new one and do some...
December 15, 2009 at 8:00 am
If you look in sys.tables, you'll see that the table name is not #HoldDate. It's actually #HoldDate__________________________________<checksum here>. However you cannot just check for name like '#HoldDate%' as that'll get...
December 15, 2009 at 7:54 am
Filegroups don't have owners. Databases have owners. Schemas have owners. Objects have owners.
Sounds like he wants the database owners to be changed. Can you confirm that?
December 15, 2009 at 7:48 am
Holly Kilpatrick (12/15/2009)
I understand that an update statement is executed by the system as a delete and an insert
Not always. SQL can do either in-place updates or a split update...
December 15, 2009 at 7:44 am
amoericke (12/15/2009)
--> The database is a star schema. We'd delete around 6 million...
December 15, 2009 at 7:36 am
one-1016367 (12/15/2009)
Do you have any thoughts or prior experience regarding performance issues when using the recompile option?
It's the hammer approach. It'll work, but CPU usage will likely go up...
December 15, 2009 at 7:30 am
Bhavesh_Patel (12/15/2009)
Yes its an interview question ... and I am desperately looking for an solution.
So if I give you the answer do I get the job? The point of an...
December 15, 2009 at 7:29 am
parthi-1705 (12/15/2009)
There is no other way to protect the data other than Backup and Log.
That's the whole reason that you do backups.
In my case there is no Possible...
December 15, 2009 at 4:34 am
Is there a column that defines the order that you want to cities displayed?
Why is there a limit of one Union All. A nonsensical restriction like that makes this look...
December 15, 2009 at 4:33 am
parthi-1705 (12/15/2009)
HiActually datas are populated yesterday only i am having the backup on weekly basis thats why i could not able to get the data.
After this do you think...
December 15, 2009 at 3:26 am
Do you have a column that defines the order?
Why the limit of one union all? That sounds like something that would be given as a homework/exam question. Is that what...
December 15, 2009 at 2:55 am
If you don't have a backup, that data's not coming back.
Triggers fire as the data is deleted, in the trigger you can roll back the delete or audit it or...
December 15, 2009 at 2:54 am
What are you trying to achieve with the 'dt.TransferType IN (@TransferType)' syntax? Using a variable in an in is the same as directly comparing the column to the variable with...
December 15, 2009 at 2:39 am
It's one of the solutions. I referred you several posts ago to a 3-part series that I wrote on parameter sniffing - http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
Or, if you'd like some specific and targeted...
December 15, 2009 at 2:33 am
Viewing 15 posts - 35,281 through 35,295 (of 49,552 total)