WayneS

Forum Replies Created

Viewing 15 posts - 5,236 through 5,250 (of 5,588 total)

RE: Comparing Table Variables with Temporary Tables

memjm2003 (6/10/2009)
Excellent article !! Just a question ... what about tables define like
WITH A1 (Col1, Col2, Col3) as
(select Col11, Col12, Col13 from MyTable where Col11=5)...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 6:43 pm

#1007733
RE: Are the posted questions getting worse?

Hey gang,
A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes of Gail...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 6:14 pm

#1007723
RE: Are the posted questions getting worse?

Lynn Pettis (6/10/2009)
jcrawf02 (6/10/2009)
Lynn Pettis (6/10/2009)
Okay, venting...
We have our White House Window Washer, our PhD Candidate, our True-Relational Zealot. Do we call this one, The One Who Can't, or...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 6:07 pm

#1007721
RE: Comparing Table Variables with Temporary Tables

Andy Lennon (6/10/2009)
This is the perfect resource for Temp Table/Table Variable comparisons as far as i'm concerned. The graph is a particularly useful quick reference.
Thank you...
Well done, and many thanks.
......
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 2:05 pm

#1007660
RE: Comparing Table Variables with Temporary Tables

Steve Jones - Editor (6/10/2009)
I've put it back in the article text, so you can read it online with colored formatting.
My apologies to Wayne for not getting this done...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 9:35 am

#1007497
RE: Comparing Table Variables with Temporary Tables

Dean Cochrane (6/10/2009)
Damn good article. I knew that table variables didn't have stats computed for them, but I hadn't fully considered the implications of that.
Thank you.
One point which your article...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 9:16 am

#1007479
RE: Comparing Table Variables with Temporary Tables

Todd Johnson (6/10/2009)
I enojyed reading your article. It verfied some of the rumors I have heard over the years.
Thank you
I was wondering if you could clarify one thing for...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 6:52 am

#1007328
RE: Comparing Table Variables with Temporary Tables

Grant Fritchey (6/10/2009)
Well done. Extremely thorough, accurate, well written... but what's with the attached Word file?
I wrote the article in Word, and I had asked Steve to include it as...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 6:46 am

#1007321
RE: application hangs

Is this the application that is connecting to the sql 2000 database that is hanging, or is this that sql 2000 is hanging when the application connects to it?
We are...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 10, 2009 at 5:08 am

#1007269
RE: How To Delete Files based on some condition (like age) using SQL Server

YSLGuru (6/9/2009)
Letting a programmer make database design decissions is like letting a politician manage your checkbook; a very bad idea that often comes with disasterous results that may not show...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 9, 2009 at 8:35 pm

#1007162
RE: DBA job not busy enough

This would be a good time to work on enhancing the performance of queries.
Run a server-side trace to track the activity on your servers, getting the duration, reads and writes....
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 9, 2009 at 8:31 pm

#1007161
RE: Syntax error near select.

Not much choice... that's exactly what you need to do.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 9, 2009 at 8:24 pm

#1007159
RE: Export specific columns to excel

See if my article Automating Excel from SQL Server[/url] helps you out. Be sure to read the discussion on this article for implications of doing this on your production server.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 9, 2009 at 5:52 pm

#1007133
RE: Struggling with a CSV file

It seems that what you're being given to import is the value without a decimal point. Since you're talking about using a select case, how does dividing that number by...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 9, 2009 at 5:35 pm

#1007130
RE: Forums on your Resume/CV

Steve Jones - Editor (6/8/2009)
In my presentation this past weekend in Florida, someone asked if I thought recruiters or HR people would look over forum postings when considering a candidate...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 9, 2009 at 5:19 pm

#1007126

Viewing 15 posts - 5,236 through 5,250 (of 5,588 total)