Viewing 15 posts - 12,586 through 12,600 (of 49,552 total)
Apparently this is part of http://www.sqlservercentral.com/Forums/Topic1466854-360-1.aspx
No replies to this thread please, replies to the thread linked above.
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
June 24, 2013 at 1:34 pm
Indeed, he's referring to partitioned views, views that have multiple tables behind them, with UNION 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
June 24, 2013 at 1:29 pm
SQLIOSim is not a performance testing tool. It's a stress tester designed to hammer an IO subsystem and see if it throws errors. Perhaps try an IO performance test tool?
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
June 24, 2013 at 5:30 am
You can restore over an online database, but the restore will have to disconnect all users (or you'll have to disconnect all users) and then the restore will overwrite 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
June 24, 2013 at 4:59 am
Aadhar Joshi (6/24/2013)
Either Create new blank database and restore on it.
Why would you create a database then restore over it? Waste of time.
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
June 24, 2013 at 4:55 am
Please note: 4 year old thread.
p.s. killing long running queries is incredibly bad practice, certainly not something that should be recommended without explaining all the problems doing so can cause
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
June 24, 2013 at 4:53 am
Aadhar Joshi (6/24/2013)
I insist to ignore top clause as there are around 60 million records. when u perform top it default sorts data.
No it doesn't. A TOP just limits 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
June 24, 2013 at 4:50 am
A restore will always disconnect all users in that database and overwrite that database with the contents of the backup.
What exactly are you trying to do?
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
June 24, 2013 at 4:45 am
Why were you expecting a 20% performance improvement?
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
June 24, 2013 at 4:25 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1466654-146-1.aspx
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
June 24, 2013 at 4:24 am
The only thing that order by on an insert is guaranteed to do is assign the values of an identity column if one exists. Your select has no order by,...
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
June 24, 2013 at 3:17 am
Yes it will, that's not what I asked.
Try the backup again, exactly as you did before.
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
June 24, 2013 at 3:13 am
Try the backup again?
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
June 24, 2013 at 2:25 am
In the first query, with the abc., you're explicitly referencing the columns from the outer query, in the second without the alias, you're implicitly referencing the columns in the outer...
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
June 24, 2013 at 2:24 am
You can restrict the query workspace memory with Resource Governor. It's useful in some circumstances
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
June 24, 2013 at 2:22 am
Viewing 15 posts - 12,586 through 12,600 (of 49,552 total)