Viewing 15 posts - 39,046 through 39,060 (of 49,552 total)
akila.baskaran (5/18/2009)
Could any one suggest a common compression technique which works in all sql server 2000,2005 and 2008.
There isn't one.
SQL 2005 (from SP2 onwards) has vardecimal, SQL 2008 has...
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
May 18, 2009 at 6:00 am
viswa (5/18/2009)
IN 2005 WE HAVE OR NOT? TELL ME A WAY..
Don't shout at me.
You posted in the 2000 forums, hence I answered for SQL 2000.
In 2005 you can use...
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
May 18, 2009 at 5:50 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
May 18, 2009 at 2:01 am
viswa (5/18/2009)
With out Trigger and Deleted Objects ,can we fetch the deleted records..Is there any way?
Not in SQL 2000.
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
May 18, 2009 at 2:01 am
Yes, there's no single table restore in the native SQL tools. Some 3rd party backup tools (like litespeed) can.
You need to restore the backup as a new database, not one...
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
May 18, 2009 at 1:56 am
Corrupted table as in database corruption? (and if so, what are the errors?)
There's no way with the native tools to restore a single table. You can restore file, filegroup 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
May 18, 2009 at 12:30 am
If you're using SQL 2005 or 2008, you can use RowNumber.
Roughly, something like this
;With ContigDates (ID, BeginDt, EndDt, RowNo) AS (
SELECT ID, BeginDate, EndDate, ROW_NUMBER() OVER (Partition by ID Order...
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
May 17, 2009 at 2:27 pm
Steve Jones - Editor (5/17/2009)
Good to hear you play baseball down under.
South Africa is not Down Under. That term refers to the rather large continent somewhere to the east of...
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
May 17, 2009 at 1:50 pm
Does the user that the web app connects as have rights to that table?
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
May 17, 2009 at 6:17 am
Please read through this - Managing Transaction Logs[/url]
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
May 17, 2009 at 1:51 am
Please don't repost existing questions in new threads. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic715000-338-1.aspx
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
May 17, 2009 at 1:51 am
What's the exact DBCC DBREINDEX command that you're running and what error is it giving you?
Is this SQL 2005? (I assume it is, seeing as it's posted in the 2005...
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
May 16, 2009 at 10:32 am
Sadequl Hussain (5/16/2009)
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
May 16, 2009 at 10:27 am
Just be aware that you may have lost data due to the log rebuild. Transactions that were committed, but whose changes were not hardened to disk when the log was...
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
May 16, 2009 at 3:02 am
Indexes on bit columns work the same way as indexes on any other column type. Have a look at this blog post.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
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
May 16, 2009 at 2:56 am
Viewing 15 posts - 39,046 through 39,060 (of 49,552 total)