Viewing 15 posts - 2,416 through 2,430 (of 19,564 total)
batgirl (8/1/2014)
SQLRNNR (8/1/2014)
Ed Wagner (8/1/2014)
Fettuccinebroccoli
bocci
balloon
August 1, 2014 at 11:05 am
Keith Tate (8/1/2014)
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
and post the entire output. Once corruption has been ruled out then we can start...
August 1, 2014 at 9:46 am
Running 2012 on a desktop os that is probably running a bunch of other things at the same time?
Probably have AV enabled on the desktop too?
Disks are configured differently?
Faster disk...
August 1, 2014 at 9:34 am
You can use @@ROWCOUNT and if the @@ROWCOUNT is greater then 0 then pass a 1 to the output parameter otherwise pass a 0 to the output parameter.
July 31, 2014 at 10:17 pm
cdm33.com (7/31/2014)
Great forum by the way.Thanks a lot,
Chris
Glad you like it. Stick around and you will learn quite a bit.
July 31, 2014 at 10:04 pm
GilaMonster (7/31/2014)
Michael Valentine Jones (7/31/2014)
July 31, 2014 at 4:26 pm
If you used the query provided by Lowell, it does not create a temp table. He used a cte.
But a temp table would be efficient in handling this type...
July 31, 2014 at 2:56 pm
Steve Jones - SSC Editor (7/31/2014)
SQLRNNR (7/31/2014)
Because you just had two pina coladas?
That's completely misworded. It's "because you had just two pina coladas."
LOL
July 31, 2014 at 2:45 pm
Markus (7/31/2014)
SQLRNNR (7/31/2014)
How much freespace are you dealing with? How much freespace on the volume that houses tempdb?187 Gig of free space on the drive.
That message can be thrown...
July 31, 2014 at 2:25 pm
Christian.stringer3 (7/31/2014)
SQLRUNNR its from a database, what do you mean by doing select, where would I do that?
You used the INSERT ... VALUES method in your example.
If you look at...
July 31, 2014 at 2:23 pm
The Dixie Flatline (7/31/2014)
Ed Wagner (7/31/2014)
SQLRNNR (7/31/2014)
swasheck (7/31/2014)
July 31, 2014 at 2:18 pm
cdm33.com (7/31/2014)
Jason,Thanks for your help - i think i got it. it's a bit nerve racking testing on production.
Let's just up-vote that say 1 million times.:-D
July 31, 2014 at 2:16 pm
Viewing 15 posts - 2,416 through 2,430 (of 19,564 total)