Viewing 15 posts - 19,726 through 19,740 (of 49,552 total)
The trigger and procedure code please?
Does the java app use implicit transactions (will likely be a setting on the driver somewhere)?
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
March 15, 2012 at 2:46 pm
Optimise the queries or upgrade the IO subsystem. I recommend the former.
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
March 15, 2012 at 11:52 am
Can you please post the definition of the ScoreNote and Score tables along with all indexes that they have. Also the definitions of the following procedures and triggers: ut_Score_Update_ScoreHistory, usp_DeleteOlderGradeBookRecords_TenWeeks
Is...
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
March 15, 2012 at 11:51 am
L' Eomot Inversé (3/15/2012)
herladygeekedness (3/15/2012)
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
March 15, 2012 at 11:41 am
Slow IO subsystem generally. A slow IO is when SQL sends an IO request to the operating system and 15 seconds later the IO has not completed. The messages are...
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
March 15, 2012 at 11:10 am
Not offhand. Start with the SQL books online (product documentation)
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
March 15, 2012 at 9:41 am
Either. Saving them in SQL Server's a little easier.
SSIS isn't something you master in 10 minutes. Take some time, read the sections in Books Online.
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
March 15, 2012 at 9:36 am
DTS was a SQL 2000 and earlier feature, it was deprecated in SQL 2005. The replacement from SQL 2005 onwards is SSIS (SQL Server Integration Services)
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
March 15, 2012 at 9:24 am
Most 32 bit apps will run fine on a 64-bit OS, if the apps are somewhere else and just connecting to the SQL server then there's no work at 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
March 15, 2012 at 8:27 am
Koen Verbeeck (3/15/2012)
GilaMonster (3/15/2012)
Koen Verbeeck (3/15/2012)
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
March 15, 2012 at 8:24 am
Koen Verbeeck (3/15/2012)
Usually I use the terms interchangeably, because there's no actual difference between the unique constraint and the unique index since SQL Server 2005. (correct me if I'm mistaken)
There...
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
March 15, 2012 at 7:49 am
Koen Verbeeck (3/15/2012)
However, the syntax for creating a UNIQUE constraint is as follows:
That's the syntax for creating a unique index, not a unique constraint.
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
March 15, 2012 at 7:39 am
No, not at all.
Koen showed you how to create a unique index on multiple columns. You can do a unique constraint the same way, just specify all the columns...
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
March 15, 2012 at 7:38 am
This: http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
The use of variables is not all that common. More common would be parameters, which behave similarly to constants when it comes to row estimations
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
March 15, 2012 at 7:36 am
derekr 43208 (3/15/2012)
>>SQL is looking for value 'X'
>>According to the non-leaf index pages, 'X' on leaf page #10
>>SQL goes to find leaf...
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
March 15, 2012 at 7:31 am
Viewing 15 posts - 19,726 through 19,740 (of 49,552 total)