rbarryyoung (11/17/2008)
Well, let's see:venkat.saginath (11/17/2008)
If the user complaint you that application is running very slow. As a DBA where do you start your work ???Usually on my cell phone as I am driving to work.
wow, i'm normally still in bed at that point, you must be keen
rbarryyoung (11/17/2008)
how do you find where exactly the problem is???
Get a red felt tip pen and your office's floor plan. Find your boss's office, circle it. Done.
i prefer green felt tip
rbarryyoung (11/17/2008)
After logshipping configured,users are connecting secondary server...how can you disconnect them?
A good pair of cable-cutters will do it.
i prefer to just inconspicuously pull the rj45 plug out of the back, its extremely aggitating trying to connect all the little wires up to crimp on a new plug again when someone spots the broken cable
rbarryyoung (11/17/2008)
Log file size increasing ,..even after logshipping connfigured?? what could be the reason?
Probably some annoying user running this procedure that I gave them last week to get rid of them:
Declare @i as intSet @i = 0
Begin Transaction
While @i < 99
Begin
Insert into Users
Select 99, 'Loopy', 'Lou', 9.11;
Delete from Users Where UserID=99;
Select @i =+ 1;
End
Commit
ahh so you're the one passing this little beauty around are you 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉