DSNOSPAM (4/19/2016)

---

version is:

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1...

John Mitchell-245523 (4/19/2016)

---

It may be because AdventureWorks has some Enterprise-level features in it, and you are attempting to restore on Express edition. You can use this link for a...

Have you gone to the books section[/url] on this site?

The SQL Server Hardware by Glenn Berry and Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and...

That would be too easy for them. Just keep...

This might work for you.

PATINDEX is available in SQL Server 2005.

DECLARE @yourTable TABLE (someString varchar(100));

INSERT @yourTable

VALUES ('DDR Return PP12345'),('DDR Resturns PP12356'),('DDR Retunrs PP12367'), ('This one does not have a...

jsalzm1 (4/18/2016)

---

Thanks guys, I and a few classmates figured it out.

Luis, you don't need to be so rude. I actually have a great job lined up and I am...

Were you really so lazy that you couldn't even copy the problem? That won't get you anywhere.

If you don't have anything to test your answers, then build something. Download SQL...

This is clearly an error on how the questions and answers were posted.

I want my zero points back. :hehe:

Alan.B (4/15/2016)

---

nagkarjun1 (4/15/2016)

---

Hi Folks,

I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

Updating/defrag Stats and rebuilding...

Mark Dalley (4/15/2016)

---

Man, it worked. I could have sworn I'd already tried that.

A slight twist though, and an extra confusing factor - the original file was actually Unix format, with...

nagkarjun1 (4/15/2016)

---

Hi Folks,

I need some suggestions on doing this task. A query was catching a bad plan and keeping CPU and no of reads very high.

Updating/defrag Stats and rebuilding indexes...

Beer

Remove the "backslash r" and keep only "backslash n".

EDIT: To remove quotes, you need a format file. Check this thread for an example: http://www.sqlservercentral.com/Forums/FindPost1777839.aspx

Brandie Tarvin (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix in three steps

1. Drop procedure

2. Drop...

To get the points per game, you need to divide the points by the games played. Then you need to get the greatest value using an aggregate function and grouping...