WayneS

Forum Replies Created

Viewing 15 posts - 4,231 through 4,245 (of 5,588 total)

RE: Using Functions in a Select Statement - A good set based method?

huston.dunlap (4/30/2010)
I'm not here to discuss a specific problem I'm having, just a conceptual one to improve my overall understanding of SQL.
Let us say I am attempting to solve some...
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 30, 2010 at 6:20 pm

#1160820
RE: MCJ - The Missing Link

CirquedeSQLeil (4/30/2010)
Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I dfon't think we need licenses for each person. That's why we'd go hosted.
Don't fret about $10-20 a month difference. Pick the best...
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 30, 2010 at 6:15 pm

#1160819
RE: MCJ - The Missing Link

Lynn Pettis (4/30/2010)
Me thinks that questions like today's QotD should be on the SSCJ core exam.
I'll be curious if you think the QOD's I have coming up (on indexes... only...
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 30, 2010 at 6:13 pm

#1160818
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/30/2010)
Lynn Pettis (4/30/2010)
Should I be scared? Nearly half of those who have answered the QotD have gotten it wrong. Could be people not fully reading the question,...
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 30, 2010 at 10:59 am

#1160607
RE: Data display issue

Forget the cursor... try this instead.
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- it...
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 30, 2010 at 10:53 am

#1160601
RE: SQl TO XML

Not sure if this does what you need, but check out this link, specifically the XMLNAMESPACES. There's an example about 3/4 of the way down the page.
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 30, 2010 at 9:57 am

#1160550
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/30/2010)
WayneS (4/30/2010)
CirquedeSQLeil (4/30/2010)
Odd question just occurred to me.
Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.
sa...
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 30, 2010 at 8:51 am

#1160494
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/30/2010)
Odd question just occurred to me.
Has anybody here ever tried setting their sa account password to contain emoticons? Or any sql logon password for that matter.
sa password =...
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 30, 2010 at 5:10 am

#1160311
RE: Would You Like a Stay Interview?

I like the idea of doing this, if it's actually performed by a third party and only aggregated results are sent to the company.
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 30, 2010 at 4:59 am

#1160307
RE: Backups

Hugo Kornelis (4/30/2010)
Great question, reminding people of an often-misunderstood and very important fact.
One minor letdown (hey! Other people moan about my questions, I get to moan back;-)) is the ambiguity...
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 30, 2010 at 4:32 am

#1160301
RE: Optimization: DE-Delimiting a Semi Colon Delimited List

Use this function:
CREATE FUNCTION [dbo].[DelimitedSplit] (
@list varchar(max),
@Delimiter char(1)
)
RETURNS TABLE
AS
RETURN
-- first, need to break down into separate items.
-- See Jeff Moden's article The "Numbers" or "Tally" Table: What it is and...
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 29, 2010 at 8:09 pm

#1160130
RE: MCJ - The Missing Link

CirquedeSQLeil (4/29/2010)
The first site listed has email enabled such that an email sent to a specific mailbox will post the content immediately to the site for others to see and...
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 29, 2010 at 7:53 pm

#1160126
RE: Script without cursors

jcrawf02 (4/29/2010)
Wayne, why the isnull() and max()?
Why not just case when sp.action = 193 then 'Y' else 'N' end?
I realized I could have dropped the IsNull and just 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

April 29, 2010 at 2:07 pm

#1160050
RE: Are the posted questions getting worse?

GabyYYZ (4/29/2010)
Lynn Pettis (4/29/2010)
WayneS (4/29/2010)
Makes you wonder... Here, the OP (with 1800+ points) can't pull apart two simple nested cursors with 5 subqueries in that last nest into some reasonable...
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 29, 2010 at 1:59 pm

#1160043
RE: Are the posted questions getting worse?

Lynn Pettis (4/29/2010)
Agreed, cursors have their place, there just is just a lot of places where they are inappropriate.
IMO, the best place for cursors is in other peoples code... when...
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 29, 2010 at 1:56 pm

#1160040

Viewing 15 posts - 4,231 through 4,245 (of 5,588 total)