Viewing 15 posts - 14,161 through 14,175 (of 39,819 total)
Is this native SQL Server backup, or a third party backup?
Is it local, or to a remote drive or share?
February 28, 2012 at 2:15 pm
February 28, 2012 at 2:14 pm
You should be able to see the linked servers listed in Management Studio for all instances. As for searching across them all, you have to connect to each and then...
February 28, 2012 at 2:13 pm
It's a little hard to understand what is wrong since you haven't formatted things well. Do you mean that if you run this:
raiserror 22004 'This is a test'
You get...
February 28, 2012 at 2:10 pm
An update statement doesn't have a select. It should be like:
update a
set a.column = a.column + 1
from Table1 a
inner join table2 b
...
February 28, 2012 at 2:05 pm
Brandie Tarvin (2/28/2012)
First, create your recovery strategy and SLA on paper. Then design the backups, backup types, and database recovery models based on that.
Exactly what Brandie wrote.
February 28, 2012 at 9:46 am
dshaddock (2/28/2012)
February 28, 2012 at 8:13 am
Jan Van der Eecken (2/28/2012)
GilaMonster (2/28/2012)
Anyone for some interview questions, looks like the same ones from DBA.Stackexchangehttp://www.sqlservercentral.com/Forums/Topic1258844-146-1.aspx
Phew! Does this guy actually know ANYTHING?
He knows enough to post questions online....
February 28, 2012 at 8:12 am
I've done something similar to Gus, but I've usually then had an ETL process or replication that copied the information off to the other databases. The reason for me has...
February 27, 2012 at 9:23 am
charindex (http://msdn.microsoft.com/en-us/library/ms186323.aspx) or patindex (http://msdn.microsoft.com/en-us/library/ms188395.aspx) work well for finding places of patterns in a string.
Then substring (http://msdn.microsoft.com/en-us/library/ms187748.aspx), as Gus as done, to strip out items.
February 27, 2012 at 9:22 am
+1
GilaMonster (2/27/2012)
False.
February 27, 2012 at 8:57 am
gthomsonts (2/24/2012)
Probably not going to win any Oscars, because I don't think he's actually acting.
Not going to win any...
February 27, 2012 at 8:43 am
Bob Abernethy (2/24/2012)
Not only is it a true story, it's also an excellent example of Business Intelligence - as applied to professional...
February 27, 2012 at 8:42 am
Lynn Pettis (2/27/2012)
Just got off the phone with my new employer. I start work on March 5th, which gives me a nice one week vacation.
Excellent, just in time to...
February 27, 2012 at 8:40 am
mitzoe (2/24/2012)
February 27, 2012 at 8:38 am
Viewing 15 posts - 14,161 through 14,175 (of 39,819 total)