Viewing 15 posts - 1,006 through 1,020 (of 1,583 total)
+1 Nadrek
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 9, 2012 at 2:24 pm
klineandking (8/8/2012)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 8, 2012 at 10:07 pm
I wouldn't recommend freeing the ENTIRE PROC cache...as you'll get a performance hit the next time every new statement runs. I'd recommend you use the same DBCC command, but...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 8, 2012 at 8:06 pm
rajprabuit (8/7/2012)
I Want to backup sql server file in remote hard disk directly.But sql server takes only internal drives as backup location.
Someone help me to solve this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 8, 2012 at 7:54 pm
You're very welcome, best of luck with it :hehe:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 8, 2012 at 2:57 pm
Not certain why you'd want to do this type of thing in SQL instead of Reporting Services or Excel (but I'm sure there's reasons ;-)) - here's a great article...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 11:19 pm
dwain.c (8/7/2012)
AND l.ARTxnBusinessDate <= '1/1/2011'--@DateFrom
1. Are you actualy comparing against...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 10:53 pm
Sqlism (8/7/2012)
Question 1) these accounts shoulb be AD accounts,am i right?
Question 2) Creating Service accounts is job of DBA? I think it should be done by systems/network team(plz clarify)
Question 3)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 10:50 pm
If when installing the SQL Server you left the "Built in administrators" group enabled (or enabled it at another time) , it will
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 8:30 pm
Tried those suggestions and really didn't see any performance gain...have a few other things to try but ended up getting too busy to look at it today!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 6:47 pm
@SpringTown :: Thanks for the explanation, much appreciated!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 6:00 am
dwain.c (8/7/2012)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 7, 2012 at 5:58 am
You may be able to get away with just increasing your data file a few GB...try that first...then we can look at other options. So if you data files...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 5:56 pm
Please describe in detail your server, storage, data files, log files, tempdb location, etc...
Do you have space on other drives? Are you data files and log files all on the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 5:52 pm
i check in that table, that table is basically contains records for all log entries for the database, right now it contains 25 million records. so i need to talk...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 6, 2012 at 3:27 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,583 total)