WayneS

Forum Replies Created

Viewing 15 posts - 826 through 840 (of 5,588 total)

RE: Are the posted questions getting worse?

I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?
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 26, 2012 at 8:38 am

#1505612
RE: Calendar Tables

Sorry for the late response... I'm just getting caught up on some newsletters where I've been too busy to read.
I think that you did a great job in this 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 23, 2012 at 9:31 pm

#1504794
RE: Are the posted questions getting worse?

L' Eomot Inversé (6/20/2012)
Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would...
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 23, 2012 at 11:21 am

#1504757
RE: Are the posted questions getting worse?

Brandie Tarvin (6/19/2012)
WayneS (6/19/2012)
Brandie Tarvin (6/19/2012)
I am putting a team together to develop the next best thing in mobile computing. The device will be called Cheese and the OS will...
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 19, 2012 at 1:13 pm

#1503069
RE: Are the posted questions getting worse?

Brandie Tarvin (6/19/2012)
I am putting a team together to develop the next best thing in mobile computing. The device will be called Cheese and the OS will be called Wine...
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 19, 2012 at 9:33 am

#1502940
RE: Are the posted questions getting worse?

Stefan Krzywicki (6/18/2012)
WayneS (6/18/2012)
Ladies, Gentlemen, and Threadizens of all shapes and sizes! Come one, come all for the latest news of the day!
Me, your humble dba, from out of the...
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 19, 2012 at 9:30 am

#1502939
RE: Are the posted questions getting worse?

Evil Kraig F (6/18/2012)
WayneS (6/18/2012)
I'll be starting the new job in a couple of weeks. I'll be a DBA with a small company that some of you'll in the northeast...
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 18, 2012 at 6:26 pm

#1502537
RE: Are the posted questions getting worse?

Ladies, Gentlemen, and Threadizens of all shapes and sizes! Come one, come all for the latest news of the day!
Me, your humble dba, from out of the blue, happened 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

June 18, 2012 at 6:15 pm

#1502531
RE: Comparing Table Variables with Temporary Tables

Thank you Patrick... It is due to responses like yours that makes me want to do this.
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 18, 2012 at 5:58 pm

#1502526
RE: Performance tuning for ORM application for 2008R2 migration

Qure link
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 15, 2012 at 11:58 am

#1501831
RE: Are the posted questions getting worse?

Stefan Krzywicki (6/15/2012)
Did you see the most recent Star Trek movie?
I hope so, but you have me wondering... I show it as "upcoming"... are you seeing it somewhere?
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 15, 2012 at 10:32 am

#1501790
RE: Query help!!

10 billion rows... very impressive.
So, let's take a look at your where clause:
WHERE T1.REC_CODE <> 'O' AND T6.ENGINE_TYPE = 'J'
T6 = CAEP9_NOISE_STRINGENCY_ROUND2_S5.dbo.AIRCRAFT_REPLACEMENT_2020_05, and you're doing a table scan on...
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 14, 2012 at 9:38 am

#1501124
RE: Insert a record for every possible date within a range

Okay, I missed the "simple" ... I think Jared has 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

June 13, 2012 at 2:20 pm

#1500681
RE: Insert a record for every possible date within a range

INSERT INTO #Backups
([CalendarDate], [ServerName], [DBName], [RecoveryModel], [IsTlogShipped])
SELECT TOP
(DATEDIFF(DAY,CONVERT(VARCHAR,@FirstBackupDate,102),GETDATE()) + 1) DATEADD(DAY,ROW_NUMBER() OVER (ORDER BY [CalendarDate]) -1, @FirstBackupDate) AS [CalendarDate]
,@ServerName
,@DBName
,'D'
,@IsTlogShipped
FROM [dbo].[Calendar]
WHERE @RecoveryModel IN ('D','L')
UNION ALL
SELECT TOP
(DATEDIFF(DAY,CONVERT(VARCHAR,@FirstBackupDate,102),GETDATE()) + 1) DATEADD(DAY,ROW_NUMBER()...
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 13, 2012 at 2:05 pm

#1500673
RE: Query Help

Lynn Pettis (6/13/2012)
WayneS (6/13/2012)
Gotta love it when my messed up solution (unused cte) actually worked and solved it.
... Actually, I just plain forgot to remove it. I think they...
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 13, 2012 at 12:49 pm

#1500610

Viewing 15 posts - 826 through 840 (of 5,588 total)