Viewing 15 posts - 12,586 through 12,600 (of 49,557 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.
June 24, 2013 at 1:34 pm
Indeed, he's referring to partitioned views, views that have multiple tables behind them, with UNION ALL.
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?
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...
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.
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
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...
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?
June 24, 2013 at 4:45 am
Why were you expecting a 20% performance improvement?
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
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,...
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.
June 24, 2013 at 3:13 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...
June 24, 2013 at 2:24 am
You can restrict the query workspace memory with Resource Governor. It's useful in some circumstances
June 24, 2013 at 2:22 am
Viewing 15 posts - 12,586 through 12,600 (of 49,557 total)