WayneS

Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 5,588 total)

RE: When Do You Deploy?

Jeff Moden (2/21/2010)
"Downtime"? Heh... I've gotta Google that and find out what it means. 😉
Let me help you out... it's the term for the free time you'll be having...
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

February 21, 2010 at 8:50 pm

#1122661
RE: Repeated questions on forums

From my perspective, answering the same basic question repeatedly just reinforces what I'm in the process of learning. For instance, I wouldn't have learned as much as I have about...
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

February 21, 2010 at 8:25 pm

#1122660
RE: "Recent Posts" issue

Okay... I'm looking at the recent posts, by clicking on the "Recent Posts | Posts added today". I know that this times out after a while, and you need to...
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

February 21, 2010 at 7:09 pm

#1122641
RE: Help- Very Complex SQL query

Jeff Moden (2/21/2010)
[Please see the article others are pointing to and if you're not going to use the method correctly, then do use it at all.
Jeff, don't you mean "then...
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

February 21, 2010 at 7:05 pm

#1122640
RE: Help- Very Complex SQL query

Paul White (2/20/2010)
WayneS (2/20/2010)
...you also wouldn't be able to use the CROSS APPLY from Paul's post (which I see he has already provided a totally awesome solution that considers this).
Fixed...
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

February 21, 2010 at 7:30 am

#1122496
RE: Help- Very Complex SQL query

Paul White (2/20/2010)
sachin1sharma (2/20/2010)
Because I am using SQL Server 2000
Oh for the love of small fluffy bunnies!!! :w00t:
You did see that this is the 2008 Forum, right?
Well, this certainly...
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

February 20, 2010 at 7:35 am

#1122332
RE: Help- Very Complex SQL query

sachin1sharma (2/20/2010)
AGAIN I don't want to use CTE to achieve this.
A CTE is a pretty powerful tool - why don't you want to use it?
In a lot of cases, a...
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

February 20, 2010 at 6:05 am

#1122314
RE: Quering data from same table

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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

February 20, 2010 at 5:54 am

#1122309
RE: Help- Very Complex SQL query

Hey guys... Please read this article[/url] for all the rules in using this form of the update statement - they must be followed or you can get erroneous results!
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

February 19, 2010 at 9:01 pm

#1122242
RE: Dynamic Crosstab Query

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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

February 19, 2010 at 3:43 pm

#1122188
RE: Automating Excel from SQL Server

Tom & Jason... 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

February 19, 2010 at 2:02 pm

#1122122
RE: Are the posted questions getting worse?

Lynn Pettis (2/18/2010)
CirquedeSQLeil (2/18/2010)
When will we see books from Jack, Lynn and Gus?
Would like to write one, just not too sure about what to write. Some people can write...
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

February 19, 2010 at 1:36 pm

#1122111
RE: Are the posted questions getting worse?

Alvin Ramard (2/17/2010)
After that I have to decide which edition of Win7 I put on the netbook. Do I really need more than Home Premium????????
When I got my Vista...
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

February 17, 2010 at 8:37 pm

#1120621
RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

CirquedeSQLeil (2/16/2010)
Here is a reference about disk alignment. SQL server likes the disks aligned and the cluster sizes to be larger than the default settings.
http://msdn.microsoft.com/en-us/library/dd758814.aspx
Jason,
Kudos for knowing about how...
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

February 17, 2010 at 6:51 pm

#1120602
RE: My First Multiple Record Update Transaction???

g_dion (2/17/2010)
Hi, I have figured out how to write a very basic update script for 1 record at a time where I SET the new value. I would like to...
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

February 17, 2010 at 3:07 pm

#1120509

Viewing 15 posts - 4,756 through 4,770 (of 5,588 total)