Viewing 15 posts - 6,286 through 6,300 (of 6,676 total)
Lookup aggregate functions in BOL.
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 23, 2008 at 4:53 pm
Note: if you are not running Enterprise Edition, locking pages in memory will not have any effect. The Standard Edition cannot lock pages in memory.
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 23, 2008 at 4:50 pm
Matt (7/23/2008)
Michael Earl (7/23/2008)
It has been my experience that complete real-time is often not really what is needed (or even...
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 23, 2008 at 3:57 pm
Tom Hamilton (7/23/2008)
Overview:
Select Action from...
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 23, 2008 at 3:23 pm
Milu (7/23/2008)
I have a table which has only one column "id" (int)and its become a default valued column, means it automatically insert "0" if value not inserted into it.
when...
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 23, 2008 at 1:26 pm
Let's walk through each one of your concerns:
jobs, alerts, operators, linked servers, saved ssis (dts) packages, users, re-set up SQL Server Mail on the new server
Jobs - stored in MSDB...
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 23, 2008 at 1:14 pm
It will delete all backup files that meet the requirements in the subfolders. So, if you have it setup to delete .bak files older than 1 day - that...
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 23, 2008 at 12:58 pm
Verify the version on your client system. I am betting that your client software has not been upgraded to the correct version.
Both your server and the client need to...
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 23, 2008 at 12:17 pm
jason.stephens (7/23/2008)
GSquared (7/23/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 23, 2008 at 11:55 am
It is not just 'dirty reads' that you need to worry about when using NOLOCK. There is also the issue of duplicate data being returned.
A good example is when...
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 22, 2008 at 10:04 pm
Verify the version of the client on that laptop and compare to the version on the other clients.
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 22, 2008 at 8:46 pm
Now that the new server is up and running, all you should have to do is:
1) Shut down the current production application
a) You...
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 22, 2008 at 8:43 pm
Nuts (7/22/2008)
Hey thanks Ken.This query works fine but how do I modify this query to update the entire table?
You can also use COALESCE and NULLIF:
SELECT COALESCE(NULLIF(column, ''), 0) FROM table;
This...
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 22, 2008 at 8:32 pm
That error tells me you have made additional changes and now you have a situation where the query is trying to use your tables as aliases and cannot figure it...
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 22, 2008 at 5:39 pm
Okay, I reformatted your query and used aliases. What I found is another problem you have:
CREATE PROCEDURE usp_rptOpenTicketsByYard
AS
SELECT t.*
,ts.status
,tp.priority
,cts.Description
,tct.CallType
,u.First_Name
,u.Last_Name
,yi.YardName
,t.CreatedOn
,t.Yard
,tp.PriorityStatus
,CASE WHEN t.ProjectTicketOption = 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 22, 2008 at 2:28 pm
Viewing 15 posts - 6,286 through 6,300 (of 6,676 total)