WayneS

Forum Replies Created

Viewing 15 posts - 4,246 through 4,260 (of 5,588 total)

RE: Are the posted questions getting worse?

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 code....
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:55 pm

#1160038
RE: Backup and restore solution for 800TB of data

CirquedeSQLeil (4/29/2010)
800TB is mouth watering. It would be quite the learning opportunity.
Indeed it would be. And he did spell out Terabyte.
Maybe the OP has been off watching the db...
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:28 pm

#1160014
RE: Consider yourself a SQL Server Guru? - Solve this!

If I can solve it, then it definitely doesn't take a guru to solve this. Though they can probably make it more efficient.
-- See how this starts off with 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 29, 2010 at 1:14 pm

#1160002
RE: Are the posted questions getting worse?

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 code. And here, he...
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 12:08 pm

#1159963
RE: One column in two columns using groups of rows. Help!

This code uses an in-frequently used form of the UPDATE statement. Read the article mentioned in the code, and understand it (especially the rules) before putting this code into 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 29, 2010 at 11:51 am

#1159951
RE: How to improve a query with a like statement

Grant Fritchey (4/29/2010)
ricardo_chicas (4/29/2010)
I just did the Update statistics and retrieve the ten million rows is two minutes, so I am happy now
Thanks to all of you
Ah, so the FULL...
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 11:25 am

#1159929
RE: Script without cursors

ps. (4/29/2010)
Many thanks for the script Wayne. This took 5 ms on a database where as the earlier one took 1 min 17 secs.
Hmm, 77 secs / .005 sec =...
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 9:46 am

#1159836
RE: Are the posted questions getting worse?

Gail - welcome back... hope your break refreshed you!
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 9:35 am

#1159820
RE: Backup and restore solution for 800TB of data

D.Oc (4/29/2010)
My bet is on GB's not TB.
Especially singe "G" is right under "T" on the keyboard...
Edit: but then again, he did write out "Terabytes" in the first post...
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 9:12 am

#1159789
RE: Script without cursors

This does it without cursors.
SELECT [User] = su.name,
[Table] = so.name,
[select] = IsNull(max(case when sp.action =...
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 5:29 am

#1159568
RE: How to Read Excel Cells from SQL Server Integration Services

Ian Yates (4/28/2010)
Now if only they'd do one for FoxPro....... 🙂 (we link to a number of third party systems that use FoxPro databases)
You do know...
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 28, 2010 at 9:17 pm

#1159389
RE: Do I need a cursor?

ninel,
First, thanks for supplying the DDL and DML to create some test data... that helps!
Can anyone please help me with a query that can pull the value of the CurrentTalk...
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 28, 2010 at 9:13 pm

#1159388
RE: Do I need a cursor?

Duplicate post. Please post responses at at the other post.
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 28, 2010 at 9:08 pm

#1159387
RE: Stored Procedure Cursors

Marv-1058651 (4/28/2010)
I am executing a cursor that is taking about 40 seconds to insert into a temp table. When I execute the sql as a new query, the results are...
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 28, 2010 at 2:18 pm

#1159283
RE: How to SUM on a filtered group?

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

April 28, 2010 at 2:08 pm

#1159280

Viewing 15 posts - 4,246 through 4,260 (of 5,588 total)