Viewing 15 posts - 211 through 225 (of 372 total)
GilaMonster (10/10/2013)
Ryan007 (10/10/2013)
Do you recommend to set memory limit to a lower value in this case?
Always. I really don't like SQL and the OS fighting over memory (which they will...
October 10, 2013 at 7:18 am
inevercheckthis2002 (10/9/2013)
Kurt W. Zimmerman (10/9/2013)
4) System, Data, Logs & TempDB should be on their separate LUNs.
With sincere apologies the thread hijacking... I'm trying my best to gain...
October 9, 2013 at 11:59 am
inevercheckthis2002 (10/9/2013)
Kurt W. Zimmerman (10/4/2013)
Things I look at are:1) Are the Data, Logs & TEMPDB on RAID 1/0? or 5? and on separate LUNs?
Which are you looking for? RAID...
October 9, 2013 at 8:03 am
dwain.c (10/7/2013)
Kurt W. Zimmerman (10/7/2013)
October 8, 2013 at 10:21 am
Don't get me wrong, Dynamic SQL has it's place along with Cursors. However I have seen dynamic SQL used in places where it was not truly needed. Case...
October 8, 2013 at 9:09 am
Does your instance of SQL Server have xp_cmdshell enabled? If so you can capture the result of the DOS command "DIR" into a table variable containing the date and...
October 7, 2013 at 10:09 am
I am not clear with what the criteria you are using for deleting. Maybe an example could help.
Kurt
October 7, 2013 at 9:23 am
Stubby Bunny (10/7/2013)
Thanks for the info, I dont mind using cursors to do things as such. Until i found this forum (WAY BETTER and more expertise) I...
October 7, 2013 at 9:09 am
Stubby Bunny (10/7/2013)
Ok if you are saying a cursor is the best way to do this i'm on board, I know how to do them all quite well just getting...
October 7, 2013 at 8:44 am
When I am asked to look into a SQL Server performance issue I want to know more about the SQL Server box, hardware resources (Memory, CPUs, Disks), how is TEMPDB...
October 7, 2013 at 8:29 am
Grant Fritchey (10/7/2013)
Kurt W. Zimmerman (10/7/2013)
Grant Fritchey (10/7/2013)
Create a script that restores the database and make the procedures you need part of the script (after the...
October 7, 2013 at 8:05 am
A simple way to debug dynamic SQL is to simply print it out. Then copy/paste the output into a New Query window and see where your errors are. ...
October 7, 2013 at 7:57 am
Grant Fritchey (10/7/2013)
Create a script that restores the database and make the procedures you need part of the script (after the restore of course). You can...
October 7, 2013 at 7:47 am
aleksandar.ivanovski (10/7/2013)
I did created indexes on all FK fileds and run the following query:
Select (s-thing from 5-6 tables)
from Table_Containing_FK A
Left outer join B
on A.id1 =...
October 7, 2013 at 7:35 am
Well it sounds like you've been "around the block a few times" on these types of issues.
I've taken over the responsibility of 20+ SQL Server boxes and have...
October 4, 2013 at 8:56 am
Viewing 15 posts - 211 through 225 (of 372 total)