Viewing 15 posts - 1,171 through 1,185 (of 1,583 total)
Greg Charles (2/28/2012)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2012 at 10:52 pm
You beat me to it Nicholas! I'm always a day late and a dollar short! hehe:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2012 at 11:02 am
Growing the data files will cost you disk resources (no matter when you do it) - and with DB's that constantly grow there is no way around this but to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2012 at 10:44 am
Have you tried outputting the error to a text file? i.e. /ee:logfile.txt
Try something like this:
bcp "exec %SERVER%.dbo.Pull_Voucher_Data" queryout C:\Vouchers.txt /ee:logfile.txt
-t\t -c -S%Server1% -b2000 -T
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2012 at 10:30 am
The money datatype can only be accurate to the ten-thousandth and does it's own rounding, which if you're using it as a data type for financial calcs you may wish...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2012 at 10:22 am
No problem! Remember, the creation of the files on the local folder is very temporary (milliseconds to seconds) while they are MOVED to the proper location...suggest using "c:\temp". 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 12:37 pm
But fact that the execution plans for the procs are often cached and more likely to be reused isn't though. This isn't an option when running ad hoc select...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 12:34 pm
Distribution clean up: distribution
This job has been running on SPID 72 for 5520 minutes.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 10:10 am
Sounds to me like your "team mate" has either learned to do it one way and is afraid to learn how to do it the proper way or just refuses...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 10:00 am
Yes. It's definitely a limitation with rendering a large report across the network using the rs.exe application (you'd think there'd be some documentation on that somewhere on BOL -...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 9:41 am
I'm pretty certain there's no historical information like that pertaining to DMV's (however the experts around here may know of one). I can tell you that this information wouldn't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2012 at 9:25 am
Ditto @Divine , use that sweet thing religiously!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 23, 2012 at 2:44 pm
This is by far the most whacked out code I've ever written and would never actually use it for anything other than the fun of "trying it", but I believe...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 23, 2012 at 11:35 am
This is a good example but would this be restricted to the number of d.lid's (in this case hard-coded to only 3 line items?)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 5:45 pm
The only ways I can think of accomplishing this is to 1) do it in a reporting services report or 2) use temp tables
1) Create a reporting services report (or...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 3:25 pm
Viewing 15 posts - 1,171 through 1,185 (of 1,583 total)