Viewing 15 posts - 4,501 through 4,515 (of 6,676 total)
Jack Corbett (10/9/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
October 9, 2009 at 12:23 pm
I have found the easiest method of defragmenting database files is to backup and restore the database. When SQL Server restores a database, it creates brand new files 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 9, 2009 at 12:14 pm
GilaMonster (10/8/2009)
SELECT @XML = '<outer><inner>
value
</inner>
</outer>'
SELECT @XML = '<outer><inner>value</inner></outer>'
Edit: It's the presence/absence of line breaks. If there's a linebreak anywhere in the code block, the < and > come out correct....
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 8, 2009 at 2:50 pm
GSquared (10/8/2009)
select cast('<row A="A" />' as XML)Very weird! This even runs correctly in SSMS, and I really don't see the difference between it and the prior post. 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
October 8, 2009 at 2:38 pm
SELECT <Something> FROM SomeWhere WHERE ...
Well - that didn't work either...
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 8, 2009 at 2:14 pm
Jeffrey Williams-493691 (10/8/2009)
I played around with it a little and preview works fine, even if you put in < and > - not sure what is going on there.
Dang 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 8, 2009 at 1:39 pm
I played around with it a little and preview works fine, even if you put in < and > - not sure what is going on there.
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 8, 2009 at 1:37 pm
SELECT <column list>; FROM <your table here>
SELECT <column>
Like this?
Edit: interesting, worked on preview - then gets modified as above.
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 8, 2009 at 1:23 pm
Download and install Redgate's SQL Compare and SQL Data Compare. Use them to compare the model databases on each instance to find out what is different.
I would recommend using...
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 8, 2009 at 1:21 pm
Using the last example I had - which I am assuming is the one that you are using for JLOutcome, it should be the same as this:
if NA1=Appt1 then NA1
if...
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 6, 2009 at 9:01 am
Okay, as far as using CTE's - that is something you can look at in the future. It is just a way of 'naming' a query and using the...
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 5, 2009 at 4:50 pm
That quote is a bit mis-leading because it implies that there is something that needs to be done to 'upgrade' the database application.
The only issues that have been identified 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 5, 2009 at 4:05 pm
JuanBob (10/5/2009)
The primary reason is for scalability without the SQL 64bit costs...
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 5, 2009 at 3:32 pm
Before going down that road - can you explain why you think you need to install SQL Server 2005 32-bit on x64?
There are very few reasons why you would need...
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 5, 2009 at 1:41 pm
jez.lisle (10/5/2009)
CASE
WHEN ASV.[1st_na] IS NOT NULL THEN 'NA1'
WHEN ASV.[completion_date] = CASE
WHEN ASV.[1st_NA] IS NULL THEN ASV.[booking_date]
WHEN ASV.[1st_NA] < ASV.[booking_date] THEN ASV.[1st_NA]
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
October 5, 2009 at 9:58 am
Viewing 15 posts - 4,501 through 4,515 (of 6,676 total)