Viewing 15 posts - 4,831 through 4,845 (of 6,676 total)
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.
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 15, 2009 at 12:21 pm
Use {your production database name here};
Go
select [SchemaName] = schema_name(st.schema_id),
[TableName] = st.Name,
[ColumnName] = sc.name
from sys.columns...
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 14, 2009 at 5:46 pm
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...
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 14, 2009 at 5:42 pm
kevinwinters (7/14/2009)
*every* row of that field is null, I am trying to make every row of that field blank so I can concatenate the field...
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 14, 2009 at 5:23 pm
kevinwinters (7/10/2009)
update claimfile set recreason = ''
The computer is not a dog but it has been running for 3 hours - is...
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 14, 2009 at 4:21 pm
J.D. Gonzalez (7/14/2009)
Fast execution
(9028 row(s) affected)
Table 'CODE_DETAIL'. Scan count 4, logical...
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 14, 2009 at 2:42 pm
ed (7/14/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 14, 2009 at 2:14 pm
patrickn (7/14/2009)
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...
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 14, 2009 at 1:56 pm
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...
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 14, 2009 at 1:41 pm
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...
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 14, 2009 at 1:37 pm
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...
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 12, 2009 at 2:02 pm
GilaMonster (7/12/2009)
DELETE FROM SomeTable WHERE PrimaryKeyColumn IN...
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 12, 2009 at 11:12 am
Steve Jones - Editor (7/10/2009)
Any logic for leaving 4GB for the OS? Does it need it in 64bit?Or would you be OK running to 30GB for SQL?
Actually, more so on...
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 10, 2009 at 9:56 pm
Your client PC's are running an x86 OS - and therefore require an x86 driver to connect to a database. The client PC does not care, nor even know...
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 10, 2009 at 3:39 pm
John Paul (7/10/2009)
We have taken the Backup , But I don't have a Access for that ... please advice any other than using Back up
Without access to backups (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
July 10, 2009 at 3:28 pm
Viewing 15 posts - 4,831 through 4,845 (of 6,676 total)