WayneS

Forum Replies Created

Viewing 15 posts - 4,006 through 4,020 (of 5,588 total)

RE: Log Shipping

And you shouldn't be going around shrinking the tlog either. It grew for a reason, and unless you eliminate that reason, it will just continue to re-grow. By doing regular...
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

June 9, 2010 at 6:38 am

#1177931
RE: Select from Table Containing Ranges

Replace the entire CTE and UPDATE statement with:
UPDATE b
SET b.Cost = (SELECT TOP 1 Charge
...
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

June 9, 2010 at 6:33 am

#1177928
RE: Stored Procedure Execution

Good question Jason!
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

June 9, 2010 at 4:45 am

#1177898
RE: Bulk-Logged Mode

wrt the log file... I think the give-away here was the wording it "will be a lot smaller".
This implies that it is 100% certain to be so - and 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

June 8, 2010 at 8:43 pm

#1177770
RE: Why can't I connect to 2 sql servers with SSMS, but others can?

Lowell (6/8/2010)
Wayne it's been a while, but i had a similar issue;for me, it was my laptop, which traveled between different networks a lot. i thought it was related...
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

June 8, 2010 at 8:13 pm

#1177766
RE: Why can't I connect to 2 sql servers with SSMS, but others can?

Leo.Miller (6/8/2010)
From the timeout error it looks like the problem is load on the database server. It may be worth running some Performance counters. like CPU usage to see 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

June 8, 2010 at 8:12 pm

#1177765
RE: SP_MSforeachdb different results

What happens if you try this?
DECLARE @command varchar(1000)
SELECT @command = 'IF ''[?]'' NOT IN (''[master]'', ''[model]'', ''[msdb]'', ''[tempdb]'')
SELECT name as...
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

June 8, 2010 at 4:51 pm

#1177735
RE: Select from Table Containing Ranges

Steve,
I realize that you're pretty new to this web site. Please realize that we are all un-paid volunteers. 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

June 8, 2010 at 4:36 pm

#1177731
RE: Why can't I connect to 2 sql servers with SSMS, but others can?

The error message that I get is:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Error connecting to '<my server>'.
------------------------------
ADDITIONAL INFORMATION:
Timeout expired. The timeout period elapsed prior to completion of the operation or...
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

June 8, 2010 at 4:30 pm

#1177729
RE: rolling total trouble

Please read the best article ever written for running totals on SQL Server[/url] by MVP Jeff Moden.
If you still need assistance, please read the first link in my signature for...
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

June 8, 2010 at 2:12 pm

#1177664
RE: Un-concatenate field imported from event viewer.csv file

For rows where Field9 contains "User Account Created", there are no "Target Domain" or "Target Account ID" "columns" - they are "New Domain" and "New Account ID". Change those strings...
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

June 8, 2010 at 9:03 am

#1177517
RE: Blog Error

cute. 😀
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

June 7, 2010 at 6:24 pm

#1177270
RE: select statement error

Dept is probably a string, and thus needs to be enclosed in quotes.
SQLstr = "Select Distinct TM from PCTTS_TIME_Results where Dept = '" + Me.DropDownListDept.SelectedValue.ToString + "' order by TM"
...
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

June 7, 2010 at 5:39 pm

#1177267
RE: sql clustering

Perry Whittle (6/7/2010)
all of these can be reproduced in virtual environments for test\educational purposes! I have a tech article that details how to do this if you need it
I think...
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

June 7, 2010 at 5:34 pm

#1177266
RE: Obtain the date of datetime field

Oleg Netchaev (6/7/2010)
... When I wrote that I liked that you picked on my post, I actually meant it....
Oleg, I'm glad you clarified this... I thought you were saying 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

June 7, 2010 at 3:19 pm

#1177239

Viewing 15 posts - 4,006 through 4,020 (of 5,588 total)