Viewing 15 posts - 7,936 through 7,950 (of 49,552 total)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
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
September 3, 2014 at 8:13 am
Nope. A member of the Sysadmin role can see everything, cannot be denied any rights. A Windows Admin can be slowed down, but cannot be prevented from accessing the databases...
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
September 3, 2014 at 7:58 am
John's already answered that
John Mitchell-245523 (9/3/2014)
Better to join PAT_ACCOUNT_MANAGER to the Inserted table to do the deletes, rather than attempt to get the IDs into a scalar variable.
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
September 3, 2014 at 6:35 am
Please don't cross-post.
No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1606251-1632-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
September 3, 2014 at 6:31 am
Please don't cross-post.
No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1606251-1632-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
September 3, 2014 at 6:24 am
Still won't handle multiple row inserts.
Any time you fetch values into a variable, your trigger won't be able to handle multiple rows. You need to get rid of all those...
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
September 3, 2014 at 6:19 am
AppSup_dba (9/2/2014)
DB size - 300GB
Log drive size 100GB.
VLF count 750.
growth rate 1000MB
And take 2-3 hours...
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
September 3, 2014 at 6:17 am
jacksonandrew321 (9/3/2014)
U can shrink the log and use simple recovery mode or shrink database files.
No, please don't recommend shrinks. They really shouldn't be run without a good reason....
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
September 3, 2014 at 6:13 am
ramana3327 (9/2/2014)
2) We can't use for very large queries because it will impact the memory
Nope, nothing to do with the query size.
3) Just this feature is for small queries...
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
September 3, 2014 at 4:14 am
DBA From The Cold (9/3/2014)
Your database is going into recovery mode probably because of some form of corruption.
Really? What form of corruption sends a DB into the recovering state?
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
September 3, 2014 at 4:13 am
Distributed Replay will do the job. See Books Online for details
Seriously though, In-memory tables are NOT for general usage. They're a specialised solution to specific problems. Not something to use...
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
September 2, 2014 at 3:53 pm
Huh? Your question makes no sense.
A sandbox is a test area, somewhere people can test and investigate things without breaking anything. It has nothing to do with MOSS and nothing...
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
September 2, 2014 at 3:32 pm
Look in the 2008 and 2012 Books Online for deprecated features.
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
September 2, 2014 at 3:23 pm
Lynn Pettis (9/2/2014)
Walked away since it seemed you had it handled. 😀
I thought I did. Now, not so sure...
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
September 2, 2014 at 2:44 pm
"The inserted table only contains the rows inserted into the table. I need rows from other tables as well. Hence I can't use a set-based solution"
Err.. ok...
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
September 2, 2014 at 2:18 pm
Viewing 15 posts - 7,936 through 7,950 (of 49,552 total)