Viewing 15 posts - 11,551 through 11,565 (of 49,552 total)
Yes.
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 26, 2013 at 7:46 am
OTF (9/26/2013)
I would imagine renaming variables might be dependent on if they have been referenced by name in a front end somewhere.
They're variables, not parameters, so can only be referred...
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 26, 2013 at 7:45 am
If I saw code like that, the developer would get a stern talking to...
DECLARE @EmployeeReferenceNumber VARCHAR(20),
@EmployeeDepartment INT
@ImportRunTime smalldatetime
...
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 26, 2013 at 7:16 am
You can't bypass latches, they are essential for physical protection of the page. Besides, the latch error is a symptom of the corruption, not a cause. If you could bypass...
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 26, 2013 at 7:12 am
Yes.
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 26, 2013 at 5:44 am
Data reader and data writer, then you'll have to grant execute on either the schema or the database as there's no system role that gives just 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
September 26, 2013 at 5:05 am
Comments to state the why of the code, not the how. How I can read from the code. Why is important. Why is this being done, where does it fit...
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 26, 2013 at 4:52 am
Maybe look in Books Online what the EXISTS does (and how the IF EXISTS works) and then give it a try?
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 26, 2013 at 4:33 am
TheSQLGuru (9/26/2013)
There are many things that happen in temp tables that are not logged
Temp tables are logged. There are NO unlogged operations in SQL other than inserts into the row...
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 26, 2013 at 4:23 am
SysAdmin.
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 26, 2013 at 4:21 am
Since there's no conditional checks, mail will be sent out every single time that trigger fires, no matter whether there are any groups over 90 rows or not.
Perhaps an 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
September 26, 2013 at 3:52 am
anoop.mig29 (9/25/2013)
but where are this log files kept
Where ever you choose to put the log backups that you take. Mirroring doesn't use log backups, so where they go is irrelevant....
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 26, 2013 at 3:13 am
enriquezreyjoseph (9/25/2013)
Hi Sir Gail..Please see my Attachment..that is the result when i try to run your suggestion...
Look at what the error say and see what I almost did to your...
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 26, 2013 at 3:09 am
Execution plan is the place you would look to see 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
September 25, 2013 at 5:20 pm
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx
I'd try but that tempDB thread has worn me out.
Indeed. Though it's good to know I...
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 25, 2013 at 3:38 pm
Viewing 15 posts - 11,551 through 11,565 (of 49,552 total)