Viewing 15 posts - 41,791 through 41,805 (of 49,552 total)
Jean-François Bergeron (1/12/2009)
How does a like react?
If there's a wildcard, it's treated the same way as a between.
LIKE 'A%' becomes >= Scalar Operator('9þ') AND < Scalar Operator('B')
How does a greater...
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
January 12, 2009 at 9:23 am
With that row count, the noncluster's probably only 2 levels deep. As the table gets larger, you'll probably be able to see a small IO count difference between the two...
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
January 12, 2009 at 9:12 am
I'm debating what to replace my stolen 17" with. Despite the weight, I'm probably going to get another 17" laptop. I don't travel all that much and when I do,...
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
January 12, 2009 at 9:08 am
mhaskins (1/12/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
January 12, 2009 at 9:04 am
Jeff Moden (1/9/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
January 12, 2009 at 9:01 am
SQL has no concept of timeouts (other that lock timeouts). A timeout is a client application setting that controls how long the client app is willing to wait the server...
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
January 12, 2009 at 8:54 am
Anything in the SQL error log?
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
January 12, 2009 at 8:48 am
Data volumes
Memory
Disk speeds and usage
CPU speed
database activity
other server activity
Different indexes or statistics
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
January 12, 2009 at 8:45 am
I don't think you'll be able to do it in one step. SQL 2008 won't allow a database that's in compatibility mode 7, which is what a SQL 7 database...
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
January 12, 2009 at 8:44 am
winston Smith (1/12/2009)
what pushes the optimizer toward one index over the other if both are providing equal results?
Probably it thinks that the index that has the include columns will have...
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
January 12, 2009 at 8:39 am
Unlikely. It's not the 32 bit/64 bit. It's that you're trying to mirror between two different versions of SQL.
You can try and set it up, but I doubt it...
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
January 12, 2009 at 8:34 am
lduvall (1/12/2009)
Shouldn't the TLog backup have reduced and reallocated that unused space?
No. The tran log backup will have removed old log records and made the space inside the file...
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
January 12, 2009 at 8:32 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic634491-106-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
January 12, 2009 at 2:18 am
arup_kc (1/11/2009)
But, how SQL server identify each row? Like Oracle, it uses ROWNUM and ROWID.
SQL has no such functions. There's no documented way to get at the storage details...
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
January 12, 2009 at 2:14 am
It looks like it may have to do with deadlocks. What traceflags do you have enabled? What version of SQL?
Please post in the appropriate forum next time, not just anywhere....
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
January 12, 2009 at 2:12 am
Viewing 15 posts - 41,791 through 41,805 (of 49,552 total)