Viewing 15 posts - 4,771 through 4,785 (of 6,676 total)
Yes - change the inner joins to outer joins, example:
LEFT JOIN tableName b ON b.KeyName = a.KeyName AND b.ValueName = 'SurName'
LEFT JOIN tableName c ON c.KeyName = a.KeyName AND c.ValueName...
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, 2009 at 8:25 pm
I don't think IF statements are related to performance at all. Using IF statements is flow control - not processing so there really isn't anything that would cause a...
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, 2009 at 8:10 pm
You are going to have to join to your table multiple times - once for each value.
SELECT a.KeyName
,a.Value As DisplayName
...
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, 2009 at 7:58 pm
What are the defined workflows for the specified audience? In other words, how is your web application going to be used by specific groups of users?
How you test depends...
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, 2009 at 7:51 pm
When I see a backup file that is larger than the database, the first thing I think is that the backup file has more than one backup in 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 29, 2009 at 2:30 pm
If you want to install a new instance into a cluster, you are going to need dedicated resources for that instance. The instance is going to need it's own...
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, 2009 at 2:28 pm
Run the SQL Server Configuration Manager - this will show you all the SQL related services running on the machine.
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, 2009 at 2:26 pm
ps (7/29/2009)
Timothy Ford (7/29/2009)
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, 2009 at 2:15 pm
Since you don't need the database in full recovery model, I would change the recovery model to simple, then shrink the log file. If you don't change the recovery...
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, 2009 at 2:06 pm
TAman (7/29/2009)
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, 2009 at 1:40 pm
TAman (7/29/2009)
And what does the '00000' represent?
Select *
,stuff(stuff(right('00000' + cast(TimeValue...
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, 2009 at 1:11 pm
Assuming that your times are what you have shown, the following should work:
Use tempdb;
Go
If object_id('tempdb..#test') Is Not Null
Drop Table #test;
Go
Create Table #test (TimeValue bigint);
Go
Insert Into #test...
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, 2009 at 10:26 am
Instead of trying to figure out how to do this from T-SQL, I would look at using SMO and Powershell to build a script that connects to every server\instance 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
July 27, 2009 at 10:32 am
luckysql.kinda (7/26/2009)
Is there any way to read the DB when this is in ‘Restoring’ mode. I tried SNAPSHOT but this didn’t help.-Lucky
What exactly did you try with Snapshot? And...
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 27, 2009 at 9:55 am
dh (7/24/2009)It was done thru a maintenance plan, which checks integrity, backs up the user databases, backs up the transaction logs then rebuilds indexes. The log portion happened successfully,...
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 25, 2009 at 1:45 pm
Viewing 15 posts - 4,771 through 4,785 (of 6,676 total)