Viewing 15 posts - 9,766 through 9,780 (of 49,571 total)
Database files aren't processor-architecture specific. A database file for a 32 bit instance is identical to one for a 64 bit instance.
You're trying to attach a SQL 2008 database on...
March 8, 2014 at 6:33 am
ananda.murugesan (3/8/2014)
By default PK does not allowed duplicate values on table also not allow NULL value, Why again need to create ADD CONSTRAINT against to primary key filed?
You mean the...
March 8, 2014 at 6:30 am
Anyone?
http://www.sqlservercentral.com/Forums/Topic1548708-324-1.aspx
I have a nasty feeling that it's blocked waiting for the alter database to go through (without a WITH ROLLBACK clause, that will wait forever iirc) because of an existing...
March 7, 2014 at 8:07 am
Check if it's blocked and if so by what and on what resource.
March 7, 2014 at 6:31 am
Koen Verbeeck (3/7/2014)
Maybe the information is outdated?
"No performance comparisons", as in hard numbers. Yes, I could run some myself, right now it's not something I can be bothered with. More...
March 7, 2014 at 4:55 am
Koen Verbeeck (3/7/2014)
Denny Lee has written on the subject:Microsoft SQL Server: The Sequencing Solution
Although I guess you already knew this. 🙂
Denny Cherry?
No performance comparisons there though.
I'd be interested to see...
March 7, 2014 at 4:45 am
Sushil Dwivedi (3/7/2014)
like
1,2,3,4...failed... than it will not start from 5.. it will start...
March 7, 2014 at 4:25 am
Sushil Dwivedi (3/7/2014)
performance wise, Sequence is better than Identity
Can you show your tests and benchmarks which show this performance improvement from sequence?
we don’t have limitation in sequence like we...
March 7, 2014 at 3:43 am
Sqlsavy (3/7/2014)
Thanks. Does updating stats on heap table is of any use?
Yes
How to reduce fragmentation <30?
IndexTypeavg_fragmentation_in_percent
CLUSTERED INDEX 97.67442
CLUSTERED INDEX...
March 7, 2014 at 3:24 am
yuvipoy (3/7/2014)
Inorder to reduce the time in future to insert the...
March 7, 2014 at 3:01 am
simon_s (3/7/2014)
Do you have a ballpark youd start at for total LIO per server or for a level of percentage increase where youd start to think ouchie
Depends on the server,...
March 7, 2014 at 2:38 am
Maybe, maybe not, very hard to tell without knowing a lot about your app.
You need to test this process out in dev, first see if it's even possible in the...
March 7, 2014 at 2:28 am
Have you tested the procedure out on your dev/test server? Can it be done in the time you have?
March 7, 2014 at 2:15 am
Akayisi (3/7/2014)
Then how im suppose to see the open transactions ?
sys.dm_tran_active_transactions
sys.dm_tran_session_transactions
sys.dm_tran_locks
Lots of options. Good examples in Books Online, there's one on the page for sys.dm_exec_sessions, probably elsewhere too.
First confirm...
March 7, 2014 at 2:06 am
Akayisi (3/7/2014)
as far as i know if sys dm exec requests returns nothing there is no open transactionn. isn't it ?
No.
Nothing from exec requests means there's no currently executing statement....
March 7, 2014 at 1:45 am
Viewing 15 posts - 9,766 through 9,780 (of 49,571 total)