Viewing 15 posts - 11,161 through 11,175 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 4:44 pm
Open a case with CSS (Customer Support AKA Product Support), looks like something they need to address.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 4:38 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 12:53 pm
Ed Wagner (10/28/2013)
For example, I'm lucky I can spell SSAS, but don't ask me to go any further than that. 😀
I'm not even sure I could do that
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 11:21 am
\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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 11:14 am
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 11:05 am
It's the Database!!! (10/28/2013)
look at your post above, does it really look OK?
Yes, looks fine. All three lines had the \\ that I typed in. Middle one had single quotes,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 10:54 am
rivermorrison22 (10/28/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 10:49 am
\\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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 10:32 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 10:29 am
-- 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 10:10 am
You quoted BoL on NULLIF and then used ISNULL in an example. They do quite different things. Which are you interested in?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 9:58 am
OCTom (10/28/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 9:56 am
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 9:53 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2013 at 9:47 am
Viewing 15 posts - 11,161 through 11,175 (of 49,552 total)