Viewing 15 posts - 601 through 615 (of 984 total)
Stuart Davies (7/5/2016)
HappyGeek (7/4/2016)
Ed Wagner (7/4/2016)
ThomasRushton (7/4/2016)
HappyGeek (7/4/2016)
Ray K (7/1/2016)
whereisSQL? (7/1/2016)
Grumpy DBA (7/1/2016)
djj (7/1/2016)
Manic Star (7/1/2016)
Ed Wagner (7/1/2016)
Manic Star (7/1/2016)
Grumpy DBA (7/1/2016)
Luis Cazares (7/1/2016)
BunniesBeach
Umbrella
Fancy Drink
mmmm....beer
Brew
IPA
hops
malt
marmite
toast
Bread
Comedy
Club
Kitkat
July 5, 2016 at 1:52 am
Raghavender (7/4/2016)
TheSQLGuru (7/4/2016)
It is showing 0% completed when I checked from dm_exec_requests.
sys.dm_exec_requests only shows percent_complete for a limited subset of queries. The full list is on the MSDN documentation...
July 5, 2016 at 1:50 am
HappyGeek (7/4/2016)
Ray K (7/1/2016)
whereisSQL? (7/1/2016)
Grumpy DBA (7/1/2016)
djj (7/1/2016)
Manic Star (7/1/2016)
Ed Wagner (7/1/2016)
Manic Star (7/1/2016)
Grumpy DBA (7/1/2016)
Luis Cazares (7/1/2016)
BunniesBeach
Umbrella
Fancy Drink
mmmm....beer
Brew
IPA
hops
malt
marmite
toast
July 4, 2016 at 6:35 am
There's a nice postcode validator from Peso / Peter Larsson at http://weblogs.sqlteam.com/peterl/archive/2008/08/13/Validate-UK-postcode.aspx
July 1, 2016 at 6:50 am
I would use the QUOTENAME() function wrapped around your database name - that'll make sure that it's properly handled when building up dynamic SQL statements like this.
July 1, 2016 at 6:15 am
John Mitchell-245523 (7/1/2016)
Depends on the workload on the server, whether there are any other instances, etc, etc. I would start with six, test, and adjust as necessary.John
In part, the...
July 1, 2016 at 5:56 am
Ed Wagner (7/1/2016)
djj (7/1/2016)
BWFC (7/1/2016)
ThomasRushton (7/1/2016)
Ed Wagner (6/30/2016)
Revenant (6/30/2016)
TomThomson (6/30/2016)
djj (6/30/2016)
HappyGeek (6/30/2016)
jasona.work (6/30/2016)
Ed Wagner (6/30/2016)
Y.B. (6/30/2016)
VacationSoon
Now
Later
Sometime
Summertime
Short
Trousers
Daisy
Duke
Boys
July 1, 2016 at 5:41 am
could you please provide me with the syntax?
You've got a big WITH clause in your RESTORE statement which contains lots of options to move files around. Just add another...
July 1, 2016 at 5:39 am
Ed Wagner (6/30/2016)
Revenant (6/30/2016)
TomThomson (6/30/2016)
djj (6/30/2016)
HappyGeek (6/30/2016)
jasona.work (6/30/2016)
Ed Wagner (6/30/2016)
Y.B. (6/30/2016)
VacationSoon
Now
Later
Sometime
Summertime
Short
Trousers
July 1, 2016 at 4:24 am
Welsh Corgi (7/1/2016)
Thanks John could you kindly provide me with the syntax?
ermmm.... add "WITH REPLACE" to your command, as documented in the RESTORE documentation?
Check the impact of WITH REPLACE...
July 1, 2016 at 4:22 am
djj (6/30/2016)
Years ago, before review started, a IT staff person did an update without a where clause....
June 30, 2016 at 6:44 am
Then there was the place with the very stringent change control process - everything, no matter how minor, had to go through the full CAB.
Unless you were the Ops team....
June 30, 2016 at 6:38 am
Similar to John Mitchell's story, in that external application vendor had full access to a database server that they were maintaining for us. Unfortunately, they had a very heavy-handed...
June 30, 2016 at 6:33 am
Ed Wagner (6/30/2016)
Revenant (6/29/2016)
Ed Wagner (6/29/2016)
Luis Cazares (6/29/2016)
Ed Wagner (6/29/2016)
Ray K (6/29/2016)
Ed Wagner (6/29/2016)
Manic Star (6/29/2016)
TomThomson (6/29/2016)
Revenant (6/29/2016)
crookj (6/29/2016)
ThomasRushton (6/29/2016)
Grumpy DBA (6/29/2016)
Hugo Kornelis (6/29/2016)
WeddingCrasher
Party
Animal
The Animals
Geordies
Visor (star trek reference)
Dilithium
Crystals
Salt
Pepper
Cayenne
Porsche
Fast
Furious
June 30, 2016 at 6:23 am
Grumpy DBA (6/29/2016)
Hugo Kornelis (6/29/2016)
WeddingCrasher
Party
June 29, 2016 at 8:14 am
Viewing 15 posts - 601 through 615 (of 984 total)