WayneS

Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 5,588 total)

RE: help in avoiding loop

You might want to check out the 15 ways to lose your cursor[/url] articles by RBarryYoung.
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

March 23, 2010 at 2:44 pm

#1138563
RE: Need help in preparing code review check list for SPs

Are you using any catch-all queries?
Does your code utilize the "WHILE" statement?
Are recursive CTEs being utilized?
Have the execution plans for the query been analyzed FOR EACH condition of parameters?
Do 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

March 23, 2010 at 2:40 pm

#1138562
RE: Find first missing number

Here's another way (note that it uses a virtual tally table - if you already have one, jump to the final select statement). If there are no gaps, this also...
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

March 23, 2010 at 1:54 pm

#1138535
RE: Being Proactive Recovering Master Database

I'm not sure how you saved out your users, but you might want to take a look at sp_help_revlogin. It scripts them out keeping the same SID (avoiding orphaned users),...
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

March 23, 2010 at 1:29 pm

#1138514
RE: Problems making a temp table with Dynamic SQL (but not regular tables)

huston.dunlap (3/23/2010)
I am using dynamic SQL to build a query that looks like the following:
SELECT BEGDOC
INTO [#EDC-GH-GF]
FROM TABLE 1
WHERE PROCESSID = 'EDC-GH-GF'
When I use a PRINT(@QUERY) command to see 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

March 23, 2010 at 12:53 pm

#1138490
RE: How to get unused numbers from 1 to 99999

Paul - thank you for showing me an area of improvement.
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

March 23, 2010 at 9:14 am

#1138296
RE: How to get unused numbers from 1 to 99999

Peter Brinkhaus (3/23/2010)
I guess the subtal difference between Wayne's and Paul's solution is the (ORDER BY N) vs. (ORDER BY (SELECT 0)). The last one doesn't require a sort.
and
Never...
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

March 23, 2010 at 9:03 am

#1138279
RE: How to get unused numbers from 1 to 99999

Paul White NZ (3/23/2010)
Wayne,
Nice idea, but I have to say that is the least efficient in-line tally table I have ever seen!
What do you base the inefficiency on? I read...
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

March 23, 2010 at 8:27 am

#1138250
RE: Are the posted questions getting worse?

GilaMonster (3/23/2010)
WayneS (3/23/2010)
That being said, employers are still impressed by having certifications. For that reason, I feel that all the denizons of the thread would benefit from being certified... that...
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

March 23, 2010 at 8:06 am

#1138238
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/22/2010)
I also believe the same could easily be said about people with College Degrees. There is a person in our finance dept that got a degree in CS....
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

March 23, 2010 at 8:03 am

#1138232
RE: Are the posted questions getting worse?

GilaMonster (3/23/2010)
Dave Ballantyne (3/23/2010)
Not odd, ive always thought the exams are based around , can you remember obscure syntax for obscure functionality used once in a blue moon. ...
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

March 23, 2010 at 7:36 am

#1138217
RE: how do we declarea label and rollback transaction

You might want to take a look at TRY/CATCH blocks, i.e.:
BEGIN TRANSACTION
BEGIN TRY
CREATE TABLE [dbo].[XXX](
[a] [smallint] NOT NULL,
...
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

March 22, 2010 at 6:16 pm

#1137940
RE: syntax of while loops

Lynn Pettis (3/22/2010)
I'm lost. What are you trying to do and why do you feel that you need to use a cursor?
From what I can gather, there is 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

March 22, 2010 at 5:58 pm

#1137930
RE: I have successfully removed SQL Server 2005 from the SQL2 node because of a bad install

rkinney-802645 (3/22/2010)
Wayne,
How do I get rid of the SQL2? Including Cluster Admin, SQL Server Configuration Manager and SQL Server Surface Area Configuration.
Cluster Admin is an Administrator tool for managing clusters....
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

March 22, 2010 at 3:50 pm

#1137902
RE: Datetime conversion

Ganesh Lohani (3/22/2010)
Hi
I am having a difficulty of converting date time from marel to sql server.
I am able to convert to the calender date by applying...
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

March 22, 2010 at 2:47 pm

#1137848

Viewing 15 posts - 4,621 through 4,635 (of 5,588 total)