J.D. Gonzalez (7/15/2009)

---

Query used:

select

m.first_name, m.last_name, gh.*, pro.*

from enterprise.dbo.members m

inner join enterprise.dbo.group_header gh

on gh.group_num = m.group_num

left join dim_programs pro

on pro.program_code = m.program_code

where

m.group_num in ('SFVA00', 'SFA000', 'SFPA00', 'SFN000')

and date_effective =...

Kurt W. Zimmerman (7/15/2009)

---

Although SQL Server isn't supported on an NAS I managed several database servers that used NetAPP for a storage device. Stability was always an issue....

I see, you are remoting into the server and using...

Not sure what you mean by directly printing the results. You can always just right-click on the results pane and select print to print the results from a query.

Use {your production database name here};

Go

select [SchemaName] = schema_name(st.schema_id),

[TableName] = st.Name,

[ColumnName] = sc.name

from sys.columns...

Without access to the file system, your options are either backup/restore, copy database wizard (without using detach/attach method - which nobody really has had any success doing), copy database wizard...

kevinwinters (7/14/2009)

---

yes, that is the exact query.

*every* row of that field is null, I am trying to make every row of that field blank so I can concatenate the field...

kevinwinters (7/10/2009)

---

I am running this query in the query analyzer:

update claimfile set recreason = ''

The computer is not a dog but it has been running for 3 hours - is...

J.D. Gonzalez (7/14/2009)

---

I thought I'd include the statistics IO for both runs. Any assistance in interpreting this would be greatly appreciated.

Fast execution

(9028 row(s) affected)

Table 'CODE_DETAIL'. Scan count 4, logical...

ed (7/14/2009)

---

I'm sorry I was not clear "will doing a log backup on a mirror principal server while the mirror server is suspended, (typo) cause an condition where the mirror...

patrickn (7/14/2009)

---

Hello,

We loaded a monitoring tool. It shows that before we have to reboot we see a large frequency of Async_Network_IO. Seems like SQL is done loading over the information...

Since you are rebuilding - I would avoid the SP1 upgrade issue altogether by building a slipstreamed version of the installation media. Here are the instructions I used to...

I would check the object's for ID's: 1090102924, 2069582411.

And then, I would follow Gail's advice and script out everything I could including verifying whether or not someone has user objects...

Instead of importing this data and populating a column in your table, it would be much better if you created a computed column in the table instead. Using a...

GilaMonster (7/12/2009)

---

If you want to delete the oldest rows, then you need something like this (because order by is not permitted in a delete statement)

DELETE FROM SomeTable WHERE PrimaryKeyColumn IN...