Is this a new mail server that you've set up or is it one that used to work now all of a sudden doesn't work?

If it's a new one you've...

+1 Nadrek

klineandking (8/8/2012)

---

hey guys,am trying to write a sql to get the datepart from a filename in sql, the filename always varies in the table for example; i have a...

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...

rajprabuit (8/7/2012)

---

Sir,

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...

You're very welcome, best of luck with it :hehe:

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...

dwain.c (8/7/2012)

---

I'll make two other suggestions then, but for the first I must ask a question:

AND l.ARTxnBusinessDate <= '1/1/2011'--@DateFrom

1. Are you actualy comparing against...

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)...

If when installing the SQL Server you left the "Built in administrators" group enabled (or enabled it at another time) , it will

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!

@SpringTown :: Thanks for the explanation, much appreciated!

dwain.c (8/7/2012)

---

I can't help you PROBE your BITMAP (sorry but I couldn't resist ;-)), but my first suggestion would be to remove the INDEX hint and see what that does...

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...

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...