WayneS

Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 5,588 total)

RE: script out database users for the selected database

Does this get the information that you're looking for?
SELECT 'IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE name = ' + QuoteName(dp.name, char(39)) +
...
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

September 1, 2010 at 9:13 am

#1215072
RE: getutcdate during daylight savings time

This query should help you see the differences:
SELECT SYSDATETIME() AS SYSDATETIME
,SYSDATETIMEOFFSET() AS SYSDATETIMEOFFSET
,SYSUTCDATETIME() AS SYSUTCDATETIME
,CURRENT_TIMESTAMP AS [CURRENT_TIMESTAMP]
...
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

August 31, 2010 at 8:25 pm

#1214703
RE: getutcdate during daylight savings time

Well, you might want to look at the GetUTCDate and SysDateTimeOffset functions.
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

August 31, 2010 at 8:22 pm

#1214700
RE: Are the posted questions getting worse?

Alvin Ramard (8/31/2010)
CirquedeSQLeil (8/31/2010)
how about a countdown for 18000 now?
24 more :hehe:
Ok, time to turn off the email notifications.
On this thread, isn't that a given?
Actually, I have email notification set...
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

August 31, 2010 at 8:18 pm

#1214699
RE: How to Change data type in expression

simon phoenix-479217 (8/31/2010)
Is it real this can't be done? If this is true what is the reason behind this?
Thanks for the prompt response
It's pretty much impossible to have one field...
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

August 31, 2010 at 8:11 pm

#1214696
RE: THANK YOU SQL SERVER CENTRAL!!!!

Lynn Pettis (8/31/2010)
I have to agree. I have learned a lot here on SSC. Some of it from others, some of it from helping others.
I agree completely 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

August 31, 2010 at 8:09 pm

#1214694
RE: Learning Oracle

I've downloaded a free copy of Oracle before (kind of like SQL Express). This is the link to their downloads.
Edit: and this is the link to the 10g free version.
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

August 31, 2010 at 8:05 pm

#1214690
RE: How to Change data type in expression

If I understand this correctly, under one condition you want an integer, and under another condition you want a string? This can't be done. However, you can convert the integer...
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

August 31, 2010 at 7:15 pm

#1214681
RE: THANK YOU SQL SERVER CENTRAL!!!!

ANY article by Jeff will definitely provide INSIGHT into things that you have never considered.
If your "loop" is a cursor, you might want to also look at the "15 ways...
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

August 31, 2010 at 7:12 pm

#1214680
RE: Table Variable vs. Temp Table - errors?

Uncle Moki (8/31/2010)Maybe I should rephrase my question given the new info - Any idea why the type-conversion problem in the omitted CTE Section throws an error message when my...
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

August 31, 2010 at 7:09 pm

#1214678
RE: sum into new row

Lutz already showed you how to do this over here. Especially relevant is the ROLLUP clause of the SELECT statement.
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

August 31, 2010 at 7:06 pm

#1214676
RE: The most bizarre SQL issue ever

SQLWannabe (8/31/2010)
No, not yet. We've been focusing on other things. However, I will probably get back to it this week. I'm going to try dropping all the indexed views then...
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

August 31, 2010 at 6:42 pm

#1214671
RE: Large number of group bys

1. Yes, group by does use indexes, if present.
2. It sounds to me more an aspect of having large tables without supporting indexes.
Can you post an execution plan? 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

August 31, 2010 at 6:40 pm

#1214670
RE: SQL server 2005 Backup & restoration size

T.LOGANATHAN (8/30/2010)
Hi friends,
Can any one give the suggestion regarding SQL server 2005 Backup & restoration size.
My DB size 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

August 31, 2010 at 6:34 pm

#1214668
RE: SQL server 2005 Backup & restoration size

pankushmehta (8/31/2010)
If your database is in full recovery mode, you can backup the Transaction log and then shrink the file.
If your database is in simple recovery mode, you can just...
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

August 31, 2010 at 6:25 pm

#1214664

Viewing 15 posts - 3,436 through 3,450 (of 5,588 total)