Viewing 15 posts - 8,071 through 8,085 (of 9,725 total)
For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The system tables...
April 27, 2010 at 6:00 am
SQL 2k5 has dropped support for a lot of the older or "other" database types in linked server OLE DB availability. Also in SSIS, unfortunately.
If you don't have a Teradata...
April 27, 2010 at 5:57 am
If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a bit. But this is...
April 27, 2010 at 5:41 am
2cams (4/27/2010)
Why will it be this side if there is so much free space? Do you need to maintain this DB...
April 27, 2010 at 5:38 am
There are probably several folks in Albany that don't frequent this group, so don't allow lack of replies to this thread to deter you from starting a local users group.
April 27, 2010 at 4:48 am
SwaroopRaj (4/23/2010)
yep.. i thought that 'truncate' would never rollback. That was the way i was taught in past. You proved that wrong for me now.
The thing that trips most...
April 23, 2010 at 8:55 am
The person who posted the question should have specified environment. I didn't have to run the code to know the VALUES statement wouldn't work in 2005. Therefore, I chose "Error"...
April 22, 2010 at 10:28 am
Thank you. I greatly appreciate your assistance.
Now all I have to do is make sure I've got space on my HD cleared out. @=)
April 22, 2010 at 8:12 am
jcrawf02 (4/16/2010)
I wouldn't think writing a blog post would really be different from writing an article? If you're going to write a slop blog, then you'd write a slop article...
April 16, 2010 at 5:31 am
Jeff Moden (4/15/2010)
April 16, 2010 at 4:47 am
CirquedeSQLeil (4/15/2010)
Revenant (4/15/2010)
Microsoft:"As a general rule, Microsoft has a very simple policy on blogs: We expect employees to be smart and exercise good judgment. ..."
I like this stance. ...
April 15, 2010 at 11:48 am
FYI: The Ben Silverman blog link points to a parked webpage at Go Daddy.com
April 15, 2010 at 5:50 am
I'm going to have to do more research. I'm now being told this happens when disabling jobs through the GUI, not just the code.
April 9, 2010 at 6:49 am
We've apparently had the same problem. In disabling jobs (jobs that restore backups down to our Dev server) during month end, the job gets disabled but then still runs as...
April 9, 2010 at 6:26 am
durai nagarajan (4/5/2010)
yes still want to recover it because while trying inserting more than a year data may miss out that too from different sources.
You never did answer Gail's question.
Is...
April 5, 2010 at 4:10 am
Viewing 15 posts - 8,071 through 8,085 (of 9,725 total)