Viewing 15 posts - 13,246 through 13,260 (of 49,552 total)
If you want to check, you can run
KILL <session_id> WITH STATUSONLY
Run that on a session that's not rolling back and you get an error. Run it on one that is...
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
May 5, 2013 at 12:06 pm
A transaction is an atomic operation, it completes entirely or not at all. A single-statement delete is a single transaction, no matter how many rows are deleted and as such...
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
May 5, 2013 at 12:00 pm
If the connection was closed before the operation completed, it will have rolled back (or be in the process of rolling back)
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
May 5, 2013 at 10:59 am
Please note: 6 year old thread
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
May 5, 2013 at 8:49 am
AndrewSQLDBA (5/5/2013)
One, there is no Upgrade from one version of SQL to the next. Not sure what you did there. But the newer version can always ready the later version.
Not...
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
May 5, 2013 at 8:10 am
Start by updating all statistics with full scan. While SQL 2008 can use the older 2000 stats, it's not efficient about it.
If the DB is still slow afterwards, identify 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
May 5, 2013 at 8:07 am
No multi-version upgrades.
You can either upgrade your 2005 cert to 2008 (if the upgrade exams haven't expired) and then upgrade 2008 to 2012, or you can start over with 2012.
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
May 5, 2013 at 8:03 am
Identify the largest CPU users, tune the queries, repeat until performance is acceptable
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
May 5, 2013 at 6:05 am
Ninja's_RGR'us (5/4/2013)
Lynn Pettis (5/4/2013)
GilaMonster (5/4/2013)
Err... I don't know what to thinkhttp://www.sqlservercentral.com/Forums/Topic1449451-1550-1.aspx
And as long as he has been around you'd think he'd know this.
How many situations have you NEVER encountered?
I've never...
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
May 5, 2013 at 6:02 am
To be honest, I wouldn't recommend that either. It's vulnerable to SQL injection and it completely violates the software engineering principal of single responsibility. In front end development no one...
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
May 4, 2013 at 3:33 pm
Err... I don't know what to think
http://www.sqlservercentral.com/Forums/Topic1449451-1550-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
May 4, 2013 at 3:30 pm
Reconnect? Assuming that no one else has grabbed the sole allowed use, you can get back in.
If someone has, identify who, ask them politely to log off (or kill their...
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
May 4, 2013 at 1:29 pm
Nice procedure....
Which part's causing the error, what are the data types of the columns?
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
May 4, 2013 at 9:19 am
This works
Exec proce_Name 'update table set column=''TEST'' where id=1'
Those aren't double quotes, they're escaped single quotes.
I still strongly recommend against any design that requires the passing of queries or parts...
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
May 4, 2013 at 9:16 am
Huh, didn't understand that...
If you want to audit end user activity, look at the SQLAudit feature. If that doesn't meet your requirements, please explain what it is that you want...
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
May 4, 2013 at 5:34 am
Viewing 15 posts - 13,246 through 13,260 (of 49,552 total)