Viewing 15 posts - 40,876 through 40,890 (of 49,552 total)
Shane Miller (2/20/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
February 20, 2009 at 2:05 pm
Putts (2/20/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
February 20, 2009 at 2:01 pm
Lynn Pettis (2/20/2009)
And you seem to have a slight evil streak in you, too. :w00t:
I run D&D games. It's a required skill. 😀
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
February 20, 2009 at 1:58 pm
xgcmcbain (2/20/2009)
does sql server do this manually? how do u check this?
sys.dm_db_index_physical_stats
But did not know you can include columns was more concerted of pros and cons of each...
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
February 20, 2009 at 1:44 pm
angel0in (2/20/2009)
Is data files get currupted if client applications switch off the PC or network connection is broken ?
No.
Corruption in SQL is mostly cause by problems with the IO...
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
February 20, 2009 at 1:41 pm
brekher (2/20/2009)
Hi,I had started with the first trigger and 1st field but in testing I am updating all rows and need help with the insert.
Because you're not looking at the...
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
February 20, 2009 at 1:37 pm
JMF (2/20/2009)
I've changed the language of my login, and ran the dbcc command on the MSDB.
That's a lot easier.
Ok, this is not a good situation. You have corruption 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
February 20, 2009 at 1:35 pm
Lynn Pettis (2/20/2009)
Okay, Gail, put down the keyboard and back away slowly.
Never! < Clings to keyboard >
I thought you blacklisted him yesterday? What are you doing? ...
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
February 20, 2009 at 1:24 pm
Putts (2/20/2009)
SELECT * completes in about a minute and returns 2.9 million rowsSELECT DISTINCT completes in 0 seconds and returns 36 rows.
Run that with STATISTICS TIME on and see how...
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
February 20, 2009 at 1:23 pm
Half Bubble (2/20/2009)
MS kindly thinks I shouldn't be using EXEC inside a function...
Functions are not allowed to cause side effects. That restriction is checked when the function is created. Since...
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
February 20, 2009 at 1:10 pm
llokshin (2/20/2009)
Hi, logreader on transactional replication failed with this error
What error?
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
February 20, 2009 at 1:06 pm
Steve Jones - Editor (2/20/2009)
SQL does mark the physical records in a heap, AFAIK, with something to be sure they are unique.
RID (Row Identifier). An 8 byte combination 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
February 20, 2009 at 1:05 pm
Alvin Ramard (2/20/2009)
Use [Regional Office Claims Adjudication Process-Disability (ROCAP)];
A government office? That explains everything!
Did anyone notice the one he started this morning?
http://www.sqlservercentral.com/Forums/Topic661280-338-1.aspx
Full outer joins on what appear to be date...
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
February 20, 2009 at 12:54 pm
Putts (2/20/2009)
Are there certain cases where distinct have always shown to increase performance?
None. It will either have no effect (if there's already an order by) or reduce performance (in all...
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
February 20, 2009 at 12:37 pm
GSquared (2/20/2009)
Judging by that, I'm going to say there isn't a connection between that and the SPID.
I've seen docs that say there was on SQL 2000, but not on 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
February 20, 2009 at 12:32 pm
Viewing 15 posts - 40,876 through 40,890 (of 49,552 total)