Viewing 15 posts - 5,821 through 5,835 (of 6,676 total)
You could use something like:
;With cteEmp (EmpNo, AddressLine, Dob, JoinDate, timestamp, rn)
As (
Select a.empno
,a.address
...
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
December 17, 2008 at 2:26 pm
Sounds to me like this instance of SQL Server is in a cluster. If so, you need to add the other drives as dependencies for SQL Server in Cluster...
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
December 17, 2008 at 1:51 pm
SSMS will not prompt you for a parameter like that. You need to modify this yourself every time you run the script.
You can use the DATEADD function to get...
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
December 17, 2008 at 1:44 pm
Launch SQL Server Configuration Manager and change it there. That should set all appropriate permissions as needed.
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
December 17, 2008 at 12:07 pm
When you say you are running the backups with administrator credentials - what does that mean?
Can you find out what user is running the SQL Server service and what user...
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
December 17, 2008 at 11:08 am
And one final update - adding a new non-clustered index on the ID column and making it the primary key fixed the problem. I could not reproduce the deadlock.
Removed...
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
December 17, 2008 at 10:25 am
I thought I would come back here and give you all an update. I was able to actually reproduce the same issue on a newly created table. I...
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
December 17, 2008 at 10:15 am
GilaMonster (12/17/2008)
Jonathan Kehayias (12/17/2008)
Why can't I use a MessageBox.Show() in my Assembly.
<Blink> WT#@$#%$%^????????
To me that shows a fundamental lack of understanding of SQL, CLR within SQL or probably both.
This really...
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
December 17, 2008 at 9:45 am
Here is a method that does not use a CTE - and will perform much better if there is an index on the StartDtTm column:
Select r.ResourceID
...
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
December 16, 2008 at 4:06 pm
So, you have five rows being returned from the first CTE - then, you select all rows from the first CTE in the second CTE and are wondering why 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
December 16, 2008 at 2:35 pm
I guess I am still not clear on what your issue is. If I use the following:
Use tempdb;
If object_id('tempdb..#TestReplace') Is Not Null
Begin;
...
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
December 16, 2008 at 1:06 pm
Jerry - I would convert the column in the query itself. Using the temp table was just a way of showing what database was being defined from the replace...
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
December 16, 2008 at 9:31 am
Did you update statistics in 2005? Rebuild indexes? Update usage?
And finally, not related to performance - but did you run DBCC CHECKDB db WITH data_purity?
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
December 15, 2008 at 4:28 pm
Maybe this will show you what is actually happening:
If object_id('tempdb..#TestReplace') Is Not Null
Begin;
Drop Table #TestReplace;
End;
Select...
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
December 15, 2008 at 4:15 pm
GilaMonster (12/15/2008)
Ok...... Never seen that before.If it's stack dumping, you need to call customer support.
Yeah, that is what I figured was going to happen. For the short term, I...
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
December 15, 2008 at 1:56 pm
Viewing 15 posts - 5,821 through 5,835 (of 6,676 total)