Viewing 15 posts - 6,256 through 6,270 (of 6,676 total)
You were really close, review the following:
select dateadd(quarter, datediff(quarter, 0, getdate()) - 0, 0)
,dateadd(quarter, datediff(quarter, 0, getdate()) - 1, 0)
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 10:32 am
Verify the connection strings for the web application are using the SQL Server Virtual IP. My guess is that they are connecting directly to the node itself.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 10:21 am
a_sood (7/31/2008)
I have a customer who is currently running WIndows Server 2003 Standard with SQL 200 Std and is haveing memory issue. He is planning to upgrade to Windows...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 10:19 am
Glad I could help and you are up and running. The SQL Browser is required when you have named instances to identify the dynamic port that instance is running...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 10:07 am
Matthew O'Gorman (7/30/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 4:04 pm
Angelindiego (7/30/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 3:55 pm
Are you trying to create this from the designer, or from a query window. If from the designer - yes, you will get a timeout.
To avoid the timeout -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 3:49 pm
GSquared (7/30/2008)
I hadn't realized that BOL says, "EXCEPT returns any distinct values from the left query that are not also found on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 3:33 pm
Is the SQL Browser service running on the server? If not, try starting it and see if you can connect.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 3:26 pm
Angelindiego (7/30/2008)
what I need is data that I am pulling straight from the table and then based on 2 parameters data about the location. they will pass...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 3:18 pm
Just a WAG - but have you tried cycling SQL Server Agent? If not, try that and see if it has any affect.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2008 at 3:13 pm
The drop-down does not automatically search the network (or your local system) for all SQL Servers that are available. You can either select the browse for more option -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 29, 2008 at 9:42 pm
First, shrinking the database and/or the transaction log is a bad idea. Performing this nightly is even worse, as it is going to cause file level fragmentation and will...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 29, 2008 at 8:49 pm
I am not sure if there is really a performance issue - but, truncating the table is (IMHO) a bit cleaner. I do know that truncating the table will...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 29, 2008 at 2:38 pm
Fernando (7/29/2008)
The statistics were the first step to optimize the query. Indexes were...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 29, 2008 at 2:36 pm
Viewing 15 posts - 6,256 through 6,270 (of 6,676 total)