Viewing 15 posts - 11,281 through 11,295 (of 49,552 total)
Take a read through these: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
http://www.sqlservercentral.com/articles/Administration/64582/
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 17, 2013 at 9:07 am
What are the exact errors in the SQL Server 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
October 17, 2013 at 8:58 am
Tables can never use less than a page, with so few rows you won't see a difference as both tables fit within a page.
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 17, 2013 at 4:38 am
Add an ORDER BY clause to the end of the query, specifying the column that it needs to be ordered by?
Check Books Online if you're unsure of the syntax 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
October 17, 2013 at 4:37 am
born2achieve (10/16/2013)
no where i can drop the partitioning in production as it is being used now. any other hope please ?
As I said, you can:
- Install developer edition instead 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
October 16, 2013 at 9:38 pm
If I may suggest - change the dev environment to Developer edition. Firstly it's cheaper than standard, second it allows enterprise features
Otherwise you'd have to drop the partitioning prior to...
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 16, 2013 at 9:52 am
Probably missing indexes. OR requires different indexes to AND, without the query executes as a scan usually.
http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/
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 16, 2013 at 4:34 am
Gerard Silveira (10/15/2013)
Would be interesting to see the non clustered index column definition inclusive of the clustered index ... From my understanding the index would then look likeOrderDate,OrderNo,OrderNo
No. What...
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 15, 2013 at 9:05 pm
lnardozi 61862 (10/15/2013)
Without them, the transaction is left open if an error occurs during processing.
Unless XACT_ABORT is on.
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 15, 2013 at 9:04 pm
ScottPletcher (10/15/2013)
I think the code below is a reasonable interpretation, but whether it's correct or not is far from certain:
If the table definition posted is correct, the column already exists...
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 15, 2013 at 3:36 pm
Maybe ask whoever gave you that requirement for clarification? We can guess what that person meant, but we'll probably be wrong.
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 15, 2013 at 2:57 pm
jasona.work (10/15/2013)
rodjkidd (10/15/2013)
GilaMonster (10/15/2013)
rodjkidd (10/15/2013)
You up to speed yet, by your tweets sounds like a long set of flights.
Awake. Mostly. The pot of coffee that came with breakfast helped.
8...
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 15, 2013 at 2:18 pm
One retort. If he insists that TRY..CATCH is an 'inefficient way of starting a transaction', then you could start by proving to him that it doesn't start a transaction at...
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 15, 2013 at 1:31 pm
Larry Johnson-473989 (10/15/2013)
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 15, 2013 at 1:26 pm
They're two different versions with two different licenses. In licensing upgrading from 2008 to 2008 R2 is the same as upgrading from 2005 to 2008. R2 is not a patch...
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 15, 2013 at 12:51 pm
Viewing 15 posts - 11,281 through 11,295 (of 49,552 total)