WayneS

Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 5,588 total)

RE: DeadLock

Craig Farrell (10/6/2010)
Answer: No and no.
This code, as is, will not deadlock independently. There's no transaction calls.
What is the serverwide setting for isolation?
Craig, did you consider the effect of...
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

October 6, 2010 at 6:08 pm

#1233210
RE: DeadLock

Amit Pandey DeBugSQL (10/6/2010)
The Deadlock trace graphs shows the same object ID on the node2 which points to the below Stored proc.
I have a neat script that shreds 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

October 6, 2010 at 6:05 pm

#1233209
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/6/2010)
Alvin Ramard (10/6/2010)
Are we there yet?
Wow, Alvin gets two in one day.
And both on the thread!
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

October 6, 2010 at 4:56 pm

#1233196
RE: Are the posted questions getting worse?

Brandie Tarvin (10/6/2010)
Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. 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

October 6, 2010 at 2:57 pm

#1233086
RE: Are the posted questions getting worse?

GilaMonster (10/6/2010)
WayneS (10/6/2010)
[Heavy Sigh]
okay, wait mode on. This will be on your blog?
Well, yes. 😀
It's for the T-SQL Tuesday blog 'party' so *shock* *horror* you'll have to wait for 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

October 6, 2010 at 12:08 pm

#1232918
RE: Are the posted questions getting worse?

GilaMonster (10/6/2010)
WayneS (10/6/2010)
Okay, I've got a few questions:
1. Can I help?
Thanks, but I have it under control (will hack out the post this weekend)
2. Can you share the myth 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

October 6, 2010 at 11:45 am

#1232880
RE: Are the posted questions getting worse?

GilaMonster (10/6/2010)
WayneS (10/6/2010)
GilaMonster (10/6/2010)
... I have 3 table variable myths targeted.
Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can...
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

October 6, 2010 at 11:25 am

#1232855
RE: Are the posted questions getting worse?

GilaMonster (10/6/2010)
... I have 3 table variable myths targeted.
Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can enhance 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

October 6, 2010 at 8:58 am

#1232666
RE: SELECT * WHERE pattern matches XXX

This link might be helpful for 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

October 5, 2010 at 9:28 pm

#1232207
RE: Excel Worksheets

SSIS can only work with known worksheets.
However, you CAN use a Script Task, use some Excel Automation, and get a list of worksheets. However, utilizing Excel Automation on a Server...
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

October 5, 2010 at 9:26 pm

#1232206
RE: Why are we still talking about Women in Tech?

I for one look forward to when
Someday, we'll run out of "women in technology" things to talk about. That will be a good day.
becomes a reality. It 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

October 5, 2010 at 9:21 pm

#1232204
RE: Are the posted questions getting worse?

bitbucket-25253 (10/5/2010)
... how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Hmm, 9 hr drive each way, plus 2 nights in a hotel... I think I...
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

October 5, 2010 at 9:04 pm

#1232202
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/5/2010)
Woohoo - Wayne just gave me permission to post a bunch!!!!!
Actually, I wouldn't be surprised if Steve has a trigger on this thread... when it gets to 19950, 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

October 5, 2010 at 7:36 pm

#1232187
RE: Reconciliation Approach

I don't know what "large" means for you, and this will make a difference.
And it also makes a difference in what version of SQL Server you're on: 2005 or 2008/R2?
If...
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

October 5, 2010 at 7:33 pm

#1232186
RE: Excel Worksheets

And in re-reading your question, are you trying to import data from multiple worksheets of an Excel file into Sql Server?
If so, most of the previous post still applies. Use...
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

October 5, 2010 at 7:28 pm

#1232185

Viewing 15 posts - 3,001 through 3,015 (of 5,588 total)