Viewing 15 posts - 6,466 through 6,480 (of 6,676 total)
I would recommend scheduling a time when you can grow your database files. You want to have at least 20% space available in the data file (not the combined...
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
June 20, 2008 at 11:22 am
Also make sure you are in fact running SQL Server Standard and not SQL Server Express (which would limit you to a single processor).
If your application uses a single connection...
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
June 20, 2008 at 11:07 am
Lookup Common Table Expressions in BOL. You probably will need to use a recursive CTE - but it should work.
Jeff
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
June 19, 2008 at 2:09 pm
Then maybe something like:
SELECT *
FROM Customer c
INNER JOIN (SELECT DISTINCT cust_number
...
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
June 19, 2008 at 2:05 pm
anjan.ashok (6/19/2008)
CREATE PROCEDURE sp_replace_value (
@strcvalue varchar(100),
@strdesc nvarchar(100)
)
as
update testtbl set value=@strconfigvalue,desc=@strconfigdesc where value=@strconfigvalue
here assume we have value column data...
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
June 19, 2008 at 1:55 pm
mrogers (6/19/2008)
I want 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
June 19, 2008 at 1:46 pm
hayess (6/19/2008)
WHERE (c.CustomerID = '3942') AND (ol.DetailTableID '6/17/2008') AND (o.Opendate < '6/19/2008') AND (ol.PLU LIKE 'ONL-ANN%') OR...
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
June 19, 2008 at 1:43 pm
Not automatically, but easy enough using SQL:
ALTER DATABASE db1 SET COMPATIBILITY_LEVEL = 90;
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
June 19, 2008 at 12:43 pm
Yep - that would do it. Dang, didn't even see it myself - probably should put my glasses on :hehe:
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
June 19, 2008 at 12:40 pm
You can use either of these techniques:
-- find all missing rows in table2
SELECT ...
FROM table1 t1
LEFT JOIN table2 t2 ON t2.pk = t1.pk
WHERE t2.pk...
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
June 19, 2008 at 12:31 pm
I don't see anything obviously wrong with the syntax, but could this be caused by one (or more) of the sub-queries is returning a NULL?
Try wrapping each sub-query with COALESCE...
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
June 19, 2008 at 12:28 pm
John Rowan (6/19/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
June 19, 2008 at 11:46 am
Have you ever run a full backup on that database? Was this database created on the DEV system or restored from live?
If this is a brand new database created...
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
June 19, 2008 at 9:06 am
John - start here: http://www.sqlservercentral.com/articles/Best+Practices/61537/
I have no idea how to help you out with this, you have posted a new script with changes to it and it just opens up...
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
June 19, 2008 at 8:57 am
Without the client tools, you will have to resort to SQLCMD, OSQL, or some other client tool. You need to be able to connect to SQL Server to make...
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
June 18, 2008 at 10:28 pm
Viewing 15 posts - 6,466 through 6,480 (of 6,676 total)