Viewing 15 posts - 11,551 through 11,565 (of 49,562 total)
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...
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
...
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...
September 26, 2013 at 7:12 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.
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...
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?
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...
September 26, 2013 at 4:23 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...
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....
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...
September 26, 2013 at 3:09 am
Execution plan is the place you would look to see that.
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...
September 25, 2013 at 3:38 pm
Viewing 15 posts - 11,551 through 11,565 (of 49,562 total)