Viewing 15 posts - 53,341 through 53,355 (of 59,064 total)
Always select just the columns that you need.
That goes without saying for the most part. But, again, I want to remind everyone that the OP said that Microsoft said...
December 27, 2007 at 9:22 am
You bet...
Personally, what I'd rather see is a real DATETIME column and a CALCULATED column to provide the varchar version that the GUI needs. Somewhere down the line,...
December 27, 2007 at 9:20 am
JohnG (12/27/2007)
Use a return (OUTPUT) parameter as it is a much cleaner solution. You're calling a procedure and not a function. In coding, procedures are...
December 27, 2007 at 9:13 am
Heh... dang it... I keep forgetting this is an SQL Server 2k5 forum! Thanks John.
December 27, 2007 at 9:08 am
I saw that PIVOT is much faster than doing subqueries or CASE statements to transform aggregated data to columns
Jacob, if you have an example of that and a smattering of...
December 27, 2007 at 9:07 am
This needs to be run on-the-fly, by non-technical end users, maybe 5-10 times per day.
The newly-created database needs to be dropped after the routine is finished.
Why is this being done?...
December 27, 2007 at 8:43 am
Oh my... we've gone from using a new function that (apparently) can't do the job, to using a Cursor...
Heh... Let's get back to the basics folks!
Consider the following PIVOT...
December 27, 2007 at 8:20 am
Well said, Damon. Not are they only "Ambassadors", but "I always keep in the back of my mind that a DBA is the" first scape-goat when something goes wrong....
December 27, 2007 at 7:16 am
No problem... I absolutely agree with you... unnecessary overhead should always be avoided even if performance is ok for now... someday, the scale will change and if the code isn'tready...
December 27, 2007 at 7:13 am
Heh... if you write the query right, you won't need a progress bar... it'll just be done.
December 27, 2007 at 7:11 am
... and be limited to 4k bytes... 😉
December 27, 2007 at 7:09 am
The script that Minaz points out is for the data... not the table schema.
There is no way to audit changes/modifications to a table's schema in SQL Server 2000 through the...
December 27, 2007 at 5:33 am
!! DIR C:\Temp
Not real sure I'm happy about THAT working because the following also works...
!! DEL C:\Temp\some file name
Great article of tips, Steve... thanks.
December 27, 2007 at 5:26 am
Now that would be a good reason... can't see it making much of a difference in non-looping batch code, but I can see where it could make a heck of...
December 27, 2007 at 5:14 am
Viewing 15 posts - 53,341 through 53,355 (of 59,064 total)