WayneS

Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 5,588 total)

RE: Iterating trough a recordset, with a unknown nr. columns / and a identifier that is non sequential (1,2,3,4..)

Consider using the ROW_NUMBER() function to assign sequential record numbers.
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

April 8, 2011 at 7:13 am

#1309134
RE: Date - without the time

Ian Scarlett (4/8/2011)
Does the date you will be comparing (e.g. @SomeDate in your example) contain a time element?
If not, then you won't have a problem, as both the lookup table...
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

April 8, 2011 at 7:10 am

#1309129
RE: Row to Colums - please help a Newbie

vilonel (4/8/2011)
it will differ from employee but max will be 10 - Thank you
Please check out the two links in my signature dealing with Cross-Tabs and Pivot tables - parts...
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

April 8, 2011 at 7:06 am

#1309123
RE: The Standard Edition Wish List

Craig Farrell (4/8/2011)
I'm with the others, partitioning. Primarily because I'd like to be able to test my partitions in dev/qa BEFORE it wanders up to production, and a lot...
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

April 8, 2011 at 7:04 am

#1309120
RE: Performing queries on multiple servers

Check out the FROM clause in Books-OnLine (BOL). The table on the report server will need to be specified in 4-part naming (Server.Database.Schema.Table).
Edit: Where Server = the Linked Server name...
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

April 8, 2011 at 6:54 am

#1309113
RE: Queries Help

Most hotels that I've stayed in have different rates, depending on the day of the week, events in town during that time period, etc. You might end up needing 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

April 8, 2011 at 6:52 am

#1309111
RE: Are the posted questions getting worse?

Kiara (4/8/2011)
Frankly, I learn more when I get a QotD wrong than when I get it right. The points are meaningless - the knowledge, on the other hand, is priceless.
Awesome...
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

April 8, 2011 at 6:41 am

#1309104
RE: Logged Operations

Ignacio A. Salom Rangel (4/7/2011)
Tom.Thomson (4/7/2011)
CirquedeSQLeil (4/7/2011)
I'll put it out there that I missed it because I went with the none option (meaning all are logged based on question phrasing)....
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

April 7, 2011 at 6:01 pm

#1308912
RE: Logged Operations

CirquedeSQLeil (4/7/2011)
In an effort to clarify - a request has been sent to Paul Randal on the subject.
FYI, Paul has responded (via Twitter):
"Tell them I said all vstore activity is...
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

April 7, 2011 at 2:15 pm

#1308821
RE: Are the posted questions getting worse?

GilaMonster (4/7/2011)
WayneS (4/7/2011)
GilaMonster (4/7/2011)
WayneS (4/7/2011)
I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be coming from those looking...
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

April 7, 2011 at 11:06 am

#1308694
RE: Are the posted questions getting worse?

Thanks Ron - I think you summarized it very well. I did deliberately throw myths in there to try to trip up people - figured it would be a good...
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

April 7, 2011 at 11:00 am

#1308688
RE: Are the posted questions getting worse?

GilaMonster (4/7/2011)
WayneS (4/7/2011)
I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be coming from those looking to bash...
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

April 7, 2011 at 10:52 am

#1308681
RE: Are the posted questions getting worse?

So, what did you'll think of the QotD? I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be...
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

April 7, 2011 at 10:23 am

#1308663
RE: Logged Operations

Hugo Kornelis (4/7/2011)
Good question, Wayne!
I especially liked the link to Gail's blog. I figured that the table variable option was the correct answer and answered without contemplating the version store...
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

April 7, 2011 at 10:06 am

#1308655
RE: Logged Operations

mohammed moinudheen (4/7/2011)
It is very tough to get this question right:)
Actually, I meant it to be tough. The other choices are all myths that a lot of people believe,...
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

April 7, 2011 at 10:01 am

#1308649

Viewing 15 posts - 1,546 through 1,560 (of 5,588 total)