Viewing 15 posts - 61 through 75 (of 1,157 total)
BWFC (3/6/2014)
MysteryJimbo (3/6/2014)
Great Britain (UK minus Northern Ireland) itself is about 8 hours east to west and about 16 hours north to south depending on your location and traffic. Telford...
March 6, 2014 at 4:17 am
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in the world, you could drive through the...
March 6, 2014 at 4:08 am
Koen Verbeeck (3/6/2014)
paul.knibbs (3/6/2014)
MysteryJimbo (3/6/2014)
Great Britain (UK minus Northern Ireland) itself is about 8 hours east to west and about 16 hours north to south depending on your location and...
March 6, 2014 at 4:06 am
Jack Corbett (3/5/2014)
Isn't everything close in the UK? 😀
Depends on your definition of close and the road network. Roads in the UK are far from straight and...
March 6, 2014 at 1:32 am
the.roof (3/4/2014)
Thanks everyone for your help. But for curiosity sake. How would it look with a MERGE statement?
Like this. I borrowed the CTE from Koen.
IF OBJECT_ID('tempdb..#test') IS NOT NULL...
March 4, 2014 at 9:02 am
SQLCJ (3/4/2014)
Silly me .. I was trying with MERGE... It was so simple with CTE. Thank you @Koen Verbeeck
MERGE would be useful if you wanted to update a value...
March 4, 2014 at 7:59 am
Adi Cohn-120898 (3/4/2014)
March 4, 2014 at 3:53 am
ChrisM@Work (3/4/2014)
rodjkidd (3/4/2014)
Shrewsbury - somewhere else that's on my "yet to visit" list. I'm getting almost as much out of this discussion as Gail is.
Deciding whether to wait for the...
March 4, 2014 at 3:48 am
bubby (3/3/2014)
Currently Allocated 5939.19 MBAvailable Free Space 156.59 (2%)
bubby (3/3/2014)
It is showingXYZ Simple Replication,
Can I get a syntax to change it to CHECKPOINT, as I am not using replication
I'm not...
March 3, 2014 at 9:25 am
GilaMonster (2/26/2014)
kenneth.mofokeng (2/26/2014)
I don't have clean backup. For some reason, my customer stopped weekly backup and the last backup is several month ago
Since you don't have backup , try...
February 28, 2014 at 7:11 am
No. This is not related to the engine.
Assuming the growth stopped when you stopped the process, its related to the code you have developed.
February 21, 2014 at 7:35 am
New Born DBA (2/21/2014)
Is there a way we can break down the migration into different parts so we don't run out of space.
No idea, I haven't seen it.
If you can...
February 21, 2014 at 7:28 am
george sibbald (2/20/2014)
MysteryJimbo (2/20/2014)
george sibbald (2/20/2014)
MysteryJimbo (2/20/2014)
george sibbald (2/19/2014)
That in most cases will be a full backup
You don't even need a full backup to be restored. If you...
February 20, 2014 at 4:07 am
george sibbald (2/20/2014)
MysteryJimbo (2/20/2014)
george sibbald (2/19/2014)
That in most cases will be a full backup
You don't even need a full backup to be restored. If you have a differential...
February 20, 2014 at 3:42 am
george sibbald (2/19/2014)
February 20, 2014 at 2:25 am
Viewing 15 posts - 61 through 75 (of 1,157 total)