WayneS

Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 5,588 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (4/18/2011)
WayneS (4/17/2011)
@#$%^
Had a $%^& bug bite my hand while grabbing hay for the horses... now it's all swollen and I'm off to see the doctor.
(The "bright spot"...
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 18, 2011 at 1:42 pm

#1313051
RE: Error message 'Could not find stored procedure 'dbo.IndexOptimize'

It might. But as Gail mentioned, it is more likely that the problem is poorly written code, and possibly a poorly designed database.
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 17, 2011 at 5:42 pm

#1312569
RE: temp table and dynamic sql problem

Would you post:
1. how are you creating the temp table.
2. the actual dynamic sql you are using to reference 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 17, 2011 at 5:30 pm

#1312567
RE: Are the posted questions getting worse?

@#$%^
Had a $%^& bug bite my hand while grabbing hay for the horses... now it's all swollen and I'm off to see the doctor.
(The "bright spot" in this is...
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 17, 2011 at 9:12 am

#1312514
RE: specialize or become better all round?

Yes...
Seriously, specialize, but become better all around.
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 16, 2011 at 8:50 pm

#1312477
RE: Contained database temporary tables

Peter, now I'm confused. How does this question contradict this database being independent of the instance that it's running on? That is exactly the idea behind a contained database.
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 16, 2011 at 11:41 am

#1312447
RE: How many are too many interviews?

Five seems to me to be a lot... but it probably means that they are down to you and someone else, and are having troubles deciding on which one 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

April 16, 2011 at 11:34 am

#1312446
RE: Rows to Columns (bit more advance)

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
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 15, 2011 at 7:39 am

#1312139
RE: Help required with combining rows

change it as shown in bold to:
insert into #tmp2
(urn2, str2)
SELECT t1.urn,
CAST(
(
SELECT '' + [str]
FROM #tmp t2
WHERE t2.urn = t1.urn
ORDER BY t2.id
FOR XML PATH(''),TYPE
).value('.','varchar(max)')
AS VARCHAR(MAX))
FROM #tmp t1
GROUP BY t1.urn
ORDER BY t1.urn
select...
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 14, 2011 at 2:04 pm

#1311852
RE: Contained database temporary tables

Cliff Jones (4/14/2011)
mohammed moinudheen (4/14/2011)
This is a tough one really 🙂
I agree, it is hard question and a very good one. Thanks.
I think what makes this hard is 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

April 14, 2011 at 12:29 pm

#1311790
RE: Contained database temporary tables

Another nice little tidbit of information about temporary tables in Denali: in all prior versions of SQL Server, through 2008R2, all temporary tables are created with positive object_id values. In...
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 14, 2011 at 8:16 am

#1311624
RE: Contained database temporary tables

Koen Verbeeck (4/14/2011)
Nice question, thanks.
The hint (select 2) makes the last answer "None of the above" a bit superfluous 😀
I think that hint is applied automatically to all questions with...
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 14, 2011 at 8:11 am

#1311619
RE: Can I see which stored procedures are used in SSRS reports

Jack Corbett (4/13/2011)
LutzM (4/13/2011)
I agree, the image data type is not the one someone would expect to find such valuable information. It's also strange that MS still uses the text/ntext...
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 13, 2011 at 3:19 pm

#1311354
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/13/2011)
Jack Corbett (4/13/2011)
Craig Farrell (4/13/2011)
Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest...
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 13, 2011 at 1:31 pm

#1311284
RE: Are the posted questions getting worse?

Roy Ernest (4/13/2011)
ALZDBA (4/13/2011)
Roy Ernest (4/12/2011)
You all are making me looking foolish because I am laughing when going through a SQL Forum. I am getting some strange looks. 😀
ditto :w00t:
btw...
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 13, 2011 at 8:16 am

#1311047

Viewing 15 posts - 1,501 through 1,515 (of 5,588 total)