Viewing 15 posts - 11,281 through 11,295 (of 49,563 total)
Take a read through these: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
http://www.sqlservercentral.com/articles/Administration/64582/
October 17, 2013 at 9:07 am
What are the exact errors in the SQL Server error log?
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.
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...
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...
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...
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/
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...
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.
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...
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.
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...
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...
October 15, 2013 at 1:31 pm
Larry Johnson-473989 (10/15/2013)
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...
October 15, 2013 at 12:51 pm
Viewing 15 posts - 11,281 through 11,295 (of 49,563 total)