Viewing 15 posts - 5,956 through 5,970 (of 6,676 total)
The real difference I see would be the number of CPU's. That slight difference in the execution plan could be the live system selecting a parallel plan.
Just to eliminate...
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
October 29, 2008 at 2:18 pm
Lots of space - whatever that means to you :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
October 29, 2008 at 1:39 pm
Jerry Hung (10/29/2008)
You can use YEAR(datefield) and MONTH(datefield) such as
SELECT id FROM transactions WHERE YEAR(trandate) = 2008 AND MONTH(trandate) BETWEEN 1 AND 3
YEAR is just DATEPART(year, ___), MONTH...
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
October 29, 2008 at 1:33 pm
Not sure how I can help on that other issue - looks like you have a couple of people who already have given you an answer that should work. ...
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
October 29, 2008 at 9:28 am
I am happy that worked for you - I think either YYYYMM or YYYY-MM would work the same way and ordered the way you want 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
October 28, 2008 at 10:39 pm
Try this:
Select convert(char(7), date, 120) As DatePeriod
,count(*) As Total
From TBL1
Where Status = 'OUT'
Group By
...
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
October 28, 2008 at 5:08 pm
That would be the best bet - but, if you don't find anything it is time to call the vendor. I have a feeling that regardless of what 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
October 28, 2008 at 4:03 pm
Since the backup operation will occur on ServerA - and will run in the context of the SQL Server Agent on that server, the only way I see is 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
October 28, 2008 at 4:00 pm
For passing dates into a procedure, I would recommend always passing the full date in YYYYMMDD format. The time will default to midnight.
If you can't do that - then,...
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
October 28, 2008 at 2:59 pm
What you really should have done is to create the logins before restoring the databases. Google 'sp_helprevlogin' to find a procedure for copying logins from one server to another.
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
October 28, 2008 at 2:47 pm
Are you sure those objects exist in the 'dbo' schema? And, are you sure you have permissions to grant access to those access (requires WITH GRANT privilege).
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
October 28, 2008 at 2:39 pm
Well, this is going to be a bit harder and most likely will end up going to the vendor anyways. What you need to do is isolate the trace...
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
October 28, 2008 at 1:57 pm
Search this site for Tally Table - it is exactly what you are looking for.
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
October 28, 2008 at 1:41 pm
Lookup REPLACE in Books Online:
SELECT REPLACE(description, 'Jasper Conran', 'JC') ...
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
October 28, 2008 at 1:20 pm
If you still have the trace output available - search the text data for the word 'locked'. Basically, you need to identify the request that is being returned 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
October 28, 2008 at 1:15 pm
Viewing 15 posts - 5,956 through 5,970 (of 6,676 total)