Try changing the date format to YYYY-MM-DD instead of YYYYMMDD. If that doesn't work - use the to_date function to convert the string value to a date.

Jim Murphy (6/1/2011)

---

great advice.

Also I'd put the growth to something more around 1 GB, 100 mb...

Open the Maintenance folder in SSMS, right-click on the maintenance plan and select View History. This history will break out each task and show you the status of each...

Februarius Montefrio (5/31/2011)

---

Hi,

Another interesting thing to note. It also throws this error message when the trigger is ran:

Msg 2760, Level 16, State 1, Procedure utg_TriggerName, Line 12

The specified schema...

UPDATE myTable

SET email = '' -- or NULL

WHERE name = 'A';

Before you run this, you really need to read up on UPDATE and INSERT in books online. Also,...

sam-1083699 (5/31/2011)

---

Thanks for your reply.

Please perform this action.

Open SQL SERVER, OPEN some database, right click on some table . You will see open table option if you click...

This should get you started: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx

This is the same issue you will see on Windows Vista or Windows 7. You are running into an issue with UAC - which is causing you some issues.

You...

You need to make sure you understand how the Netapp SAN has been setup and configured. If the LUNs presented for your data drive is from an aggregate with...

Barkingdog (5/29/2011)

---

Jeffrey,

You wrote

>>>>

I would expand on this - keep everything as long as you possible can. I cannot count how many times (on this site and others), where someone has...

Steve Jones - SSC Editor (5/29/2011)

---

I recommend keeping 2 fulls and the logs since around. After that, I've never seen the need to recover a database in the past to...

I have to agree with the others - this should be re-written to eliminate all of the sub-queries. Not only will that help in performance, but the query will...

While you are researching this, I would recommend that you set the trace flags to make these type of operations NO-OPS so they don't cause problems with your log chain.

http://www.sqlskills.com/blogs/paul/post/backup-log-with-no_log-use-abuse-and-undocumented-trace-flags-to-stop-it.aspx

From...

Welsh Corgi (5/27/2011)

---

Jeffrey Williams-493691 (5/27/2011)

---

Welsh Corgi (5/27/2011)

---

Lucky9 (5/27/2011)

---

If so, you could look at adding a MIN(StatusStartDate) OVER(Partition By ClientID, Status) to the CTE. Or, you could just use a...

Lee Crain (10/28/2010)

---

In addition to being my company's DBA, I'm also a certified Compellent SAN administrator.

If you want to achieve optimum performance on your database server(s), separate each of your...