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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 7:44 am
amoericke (12/15/2009)
--> The database is a star schema. We'd delete around 6 million...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 2:33 am
Viewing 15 posts - 35,281 through 35,295 (of 49,552 total)