Hey everyone and welcome back to SQL Something!
I happened to see an old post of mine (towards the bottom of the post) where I mentioned restoring from the command line but I did not actually say how.
So that's what I want to look at really quickly.
"Musings from a DBA in training." - Geon Bell
Wednesday, 29 January 2014
Monday, 27 January 2014
Convert Comma Delimited String To A Table
Welcome back to SQL Something everyone!
Just seeing if I could throw one more post in before the end of the month (trying so hard to stick to my "at least 2 posts per month" rule).
Today we'll look at how to convert a comma delimited string to a table, where each delimited value will be placed in a new row.
Just seeing if I could throw one more post in before the end of the month (trying so hard to stick to my "at least 2 posts per month" rule).
Today we'll look at how to convert a comma delimited string to a table, where each delimited value will be placed in a new row.
Thursday, 23 January 2014
Mini Post: Restore of Database Failed; Access is Denied
Happy New Year! (Albeit a little late!)
Welcome back to SQL Something!
To start off the year we'll look at a very small issue: "The operating system returned the error '5(Access is denied)' while attempting restore".
Welcome back to SQL Something!
To start off the year we'll look at a very small issue: "The operating system returned the error '5(Access is denied)' while attempting restore".
 |
| Fig. 1: Access is Denied |
Tuesday, 31 December 2013
Finding The Last Queries Run On A SQL Instance
Hey everyone! Last SQL Something post for the year 2013! :-)
Pretty happy with how the year went blog-wise (not as many posts per month as I'd hoped but still I managed to stick with it).
Anyhoo, enough about that and on to the post! Today we are looking at how to view the last few queries that ran on your databases.
Pretty happy with how the year went blog-wise (not as many posts per month as I'd hoped but still I managed to stick with it).
Anyhoo, enough about that and on to the post! Today we are looking at how to view the last few queries that ran on your databases.
Monday, 16 December 2013
Mini Post: SQL Server Configuration Manager "The Request Failed..." Error
Happy Holidays! And here is a Mini Post for you!
It's a simple error to run into. You open SQL Server Configuration Manager to start a service and this pops up: The request failed or the service did not respond in a timely fashion.
Hmmm.
It's a simple error to run into. You open SQL Server Configuration Manager to start a service and this pops up: The request failed or the service did not respond in a timely fashion.
 |
| Fig. 1: Failure... |
Hmmm.
Monday, 18 November 2013
Getting the Time Difference Between Inserted Rows (Given a DateTime Column) - SQL Server 2008
Good day and welcome to SQL Something!
I'm particularly pleased to write this one as it's the first non-MiniPost I've written in a while. Huzzah!
Today we are going to look at how to get the time difference between the insertion of two rows, given a datetime column.
I'm particularly pleased to write this one as it's the first non-MiniPost I've written in a while. Huzzah!
Today we are going to look at how to get the time difference between the insertion of two rows, given a datetime column.
Friday, 15 November 2013
Mini Post: Removing all Whitespace/NewLine Characters From a String
Hey and hello! Welcome back or welcome new!
Today really quickly we'll look at something that is very helpful in my day-to-day stuff, that is, stripping all spaces and any new line characters from a string.
You can use the below:
REPLACE(REPLACE(REPLACE(REPLACE(YourString, CHAR(9), ''), CHAR(10), ''), CHAR(13), ''), ' ', '');
This strips Tab spaces ( represented by CHAR(9) ), Line Feed spaces ( represented by CHAR(10) ), Carriage Returns ( represented by CHAR(13) ) and plain old spaces (represented by ' ').
Please see here for CHAR types.
DISCLAIMER: As stated, I’m not an expert so please, PLEASE (by all means!) feel free to politely correct or comment as you see fit. Your feedback is always welcomed. :-)
Today really quickly we'll look at something that is very helpful in my day-to-day stuff, that is, stripping all spaces and any new line characters from a string.
You can use the below:
REPLACE(REPLACE(REPLACE(REPLACE(YourString, CHAR(9), ''), CHAR(10), ''), CHAR(13), ''), ' ', '');
This strips Tab spaces ( represented by CHAR(9) ), Line Feed spaces ( represented by CHAR(10) ), Carriage Returns ( represented by CHAR(13) ) and plain old spaces (represented by ' ').
Please see here for CHAR types.
DISCLAIMER: As stated, I’m not an expert so please, PLEASE (by all means!) feel free to politely correct or comment as you see fit. Your feedback is always welcomed. :-)
Subscribe to:
Posts (Atom)