Viewing 15 posts - 11,896 through 11,910 (of 49,552 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,...
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
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...
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
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...
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
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.
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
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.
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
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
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
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...
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
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...
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
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
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
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...
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
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...
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
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.
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
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...
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
August 28, 2013 at 7:45 am
sqlnaive (8/28/2013)
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
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.
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
August 28, 2013 at 5:40 am
Viewing 15 posts - 11,896 through 11,910 (of 49,552 total)