Viewing 15 posts - 11,896 through 11,910 (of 49,562 total)
Koen Verbeeck (8/29/2013)
HanShi (8/29/2013)
You are not to be improving a table, but you need to improve the queries accessing that table.
And how can you improve a query? By updating statistics,...
August 29, 2013 at 4:01 am
Tables don't have performance. Queries have performance. Asking how to improve the performance of a table is meaningless, what you need to do is improve the performance of queries that...
August 29, 2013 at 4:00 am
They're both wrong.
Statistics associated with an index are updated with the index is rebuild. A reorganise does not touch the stats. Stats other than the ones on the index are...
August 29, 2013 at 2:58 am
Yes, checkDB works fine on Standard Edition, and all other editions. It does create the hidden snapshot on all editions.
August 29, 2013 at 2:54 am
Junglee_George (8/28/2013)
I need a help to modify my query to give comma-separated values as SP parameter. Any help is appreciated. Thanks in advance.
Try a table-valued parameter.
August 29, 2013 at 2:52 am
Can someone please help this poor gentleman deny restore rights to a sysadmin
http://www.sqlservercentral.com/Forums/Topic1489312-359-1.aspx
August 28, 2013 at 11:17 am
No, because as soon as the restore has started the files it's using get written over. You can kill it at any point, but the database being restored over will...
August 28, 2013 at 10:31 am
You cannot deny anything to a sysadmin.
You could try a DDL trigger on CREATE DATABASE, but the problem with those is they are AFTER triggers and I'm not sure if...
August 28, 2013 at 10:23 am
Same reason you can roll back a delete - the space where the rows were cannot be reused until the transaction commits
August 28, 2013 at 9:08 am
wak_no1 (8/28/2013)
Although it looks like exactly like what I need; just a snapshot of the current CPU usage/time listed by session ID!
Then see Erland's suggestion from yesterday. That's how you'd...
August 28, 2013 at 8:18 am
Well, your query won't work with comma-delimited values, so there's not much point in passing them.
IN (@Variable) is equivalent to = @Variable, so if you pass a comma-delimited list that...
August 28, 2013 at 8:17 am
It's not data type problems. It's that the procedure has only one parameter and you're passing two parameters.
August 28, 2013 at 8:05 am
Licensing for SQL Server is all about paper, the instances themselves have no idea how they are licensed.
Go speak with whoever did the software purchasing or is responsible for vendor...
August 28, 2013 at 7:45 am
sqlnaive (8/28/2013)
August 28, 2013 at 7:40 am
Pretty sure that requires an uninstall/reinstall
Bear in mind that developer edition is not licensed for production usage.
August 28, 2013 at 5:40 am
Viewing 15 posts - 11,896 through 11,910 (of 49,562 total)