Viewing 15 posts - 9,766 through 9,780 (of 49,552 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...
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 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...
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 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...
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 7, 2014 at 8:07 am
Check if it's blocked and if so by what and on what resource.
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 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...
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 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...
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 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...
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 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...
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 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...
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 7, 2014 at 3:24 am
yuvipoy (3/7/2014)
Inorder to reduce the time in future to insert the...
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 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,...
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 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...
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 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?
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 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...
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 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....
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 7, 2014 at 1:45 am
Viewing 15 posts - 9,766 through 9,780 (of 49,552 total)