No it does not work, hasn't worked since 2000. No, you cannot force tables into cache, there's no need, SQL's memory management and buffer management is good enough. PinTable tended...

Open a case with CSS (Customer Support AKA Product Support), looks like something they need to address.

That's mostly new stuff. The old windowing functions from SQL 2008 still work, they haven't been broken. There's additional functionality, but your 2008 book should still be fine for the...

I'm not even sure I could do that

\n = either CR or LF, the new line character on unix. Anything other than n after the slash works fine. Took me a while to realise he meant a...

Pretty much script all objects (including users with their permissions if applicable), export all data, recreate the DB

Or you could leave it on SQL 2012 and use the 2008 books,...

Yes, looks fine. All three lines had the \\ that I typed in. Middle one had single quotes,...

rivermorrison22 (10/28/2013)

---

If you had an employee table with a clustered index by employeeID, and a non-clustered index by lastname, would the nonclustered index contain a sorted list of last names,...

\\etwordrive

'\\etwordrive\SQLPrivateKey'

\\etwordrive\SQLPrivateKey

Looks OK to me.

does \\drive exist? Does the SQL Server service account have write permissions? Does the file already exist?

Could you post the exact code you're running?

Not really misleading. Function name ISNULL. It checks if the first parameter is null, if so it returns the second, otherwise returns the first. In this case the first parameter...

-- Back up the full mydatabase. -- This is the script I get the error

BACKUP DATABASE [mydatabase] TO '\\server05\sqlbackups\mydatabase.bak';

GO

BACKUP CERTIFICATE [mydatabase Encryption Certificate]

TO FILE = '\\server05\sqlbackups\EncryptionCert'

WITH PRIVATE KEY

(FILE = '\\server05\sqlbackups\PrivateKeyFile',

ENCRYPTION...

You quoted BoL on NULLIF and then used ISNULL in an example. They do quite different things. Which are you interested in?

OCTom (10/28/2013)

---

That's a no-win for the candidate. I was asked to rate myself once. I rated myself a 9 on the technology. The interviewer said that's impossible; no one can...

Posts don't discard slashes or add spaces.

You have a leading space in your last file reference. You have a missing '\' in all of your file references.

Ok, first ditch the dump device. I don't know anyone who uses them. Besides, that's not a valid file path, so that won't work anyway.

EXEC sp_addumpdevice 'disk', mydatabase Device',

'\etworkdrive\mydatabase.bak';

BACKUP...