Viewing 15 posts - 43,561 through 43,575 (of 49,552 total)
How many pages?
As I said, smaller tables will not have fragmentation reduced to 0, and it's nothing to be concerned about
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
October 26, 2008 at 3:18 am
It has to do with how the first few pages of the table are allocated. How many pages are there in this 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
October 25, 2008 at 3:27 pm
How big is the table, how many rows, how many pages? (sys.dm_db_index_physical_stats will tell you that)
If I had to guess, I'd say this is a really small table, less than...
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
October 25, 2008 at 2:43 pm
Jeff Moden (10/21/2008)
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
October 25, 2008 at 2:36 pm
Andy Leonard (10/25/2008)
Technically, I grew up here (at SSC).
Likewise. I found this site when I was just getting started with SQL. Initially it was the question of the day 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
October 25, 2008 at 11:19 am
Grant Fritchey (10/25/2008)
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
October 25, 2008 at 6:00 am
You have to aggregate, but what you can do is to add a fake column in which you then ignore.
This more or less gets want you want. I don't understand...
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
October 25, 2008 at 5:57 am
Here's a schedule for all the SQL 2008 exams:
http://blogs.msdn.com/gerryo/archive/2008/10/24/weekly-exam-status-update.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
October 25, 2008 at 3:20 am
Can you please post some sample data and your desired output.
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
October 25, 2008 at 3:01 am
Jeff Moden (10/24/2008)
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
October 25, 2008 at 2:56 am
On my 2008 box, it varies. First one is faster then the other, but it's a difference of around 20ms over 1000000 executions, So works out at about 20 nanoseconds...
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
October 25, 2008 at 2:54 am
Oh, and also, the name in sys.types will never return varchar(max), nvarchar(max) or varbinary(max). They'll return varchar, nvarchar or varbinary. To see if it's max or a defined length, check...
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
October 24, 2008 at 4:06 pm
Exists just checks whether or not the resultset returns a row. In your exists, there is no link between the subquery and the outer query. Hence the exists will return...
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
October 24, 2008 at 3:59 pm
In that case, to figure this out you're going to need to figure out where it's getting called from. If that's the only query in the proc, then the processes...
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
October 24, 2008 at 3:26 pm
Is that all that's in that proc? The deadlock graph refers to an update on Line 15.
Also, the deadlock details indicate that the processes both had exclusive locks and...
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
October 24, 2008 at 3:08 pm
Viewing 15 posts - 43,561 through 43,575 (of 49,552 total)