Viewing 15 posts - 6,181 through 6,195 (of 6,676 total)
Jeff Moden (8/10/2008)
And, yes, I agree... it's probably better to store the name of the file...
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
August 10, 2008 at 6:06 pm
rbarryyoung (8/10/2008)
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
August 10, 2008 at 3:11 pm
Jeff Moden (8/10/2008)
Again, I ask... do you have to update usage for the rowcounts to be accurate?
Well, according to BOL - no, you don't have to update usage.
Reports and corrects...
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
August 10, 2008 at 11:40 am
I have absolutely no idea on what additional information you need. How you implement storing image data in SQL Server all depends upon what you need to do.
For example,...
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
August 10, 2008 at 10:49 am
For SQL Server 2005 and greater - there is no need to cursor at all. Just use the DMV sys.dm_db_partition_stats as in the following:
Select object_schema_name(object_id) As SchemaName
...
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
August 10, 2008 at 10:43 am
Instead of dropping/recreating the indexes - look at just disabling the indexes and rebuilding them after the process has completed.
ALTER INDEX index ON table DISABLE; --disables the index
You still...
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
August 10, 2008 at 10:10 am
Use the varbinary(max) data type. Also, look at SQO Server 2008 and filestream objects, which will work a lot better when storing this kind of data.
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
August 10, 2008 at 10:04 am
To upgrade your client tools, you need to run the service pack upgrade on your PC. You validate that the client tools have been upgraded by going to Help...
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
August 9, 2008 at 8:04 pm
Disregard my previous post - I see the problem you are having. Stored procedures are created and stored in the database - not in the report.
Open SSMS, connect 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
August 8, 2008 at 8:49 pm
Can you also post your full create procedure statement? And, please try executing the procedure in a query window as:
Execute 'your procedure name here';
And post the results of 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
August 8, 2008 at 8:41 pm
Lookup linked servers in Books Online. What you are going to need to do is install the ODBC drivers for Oracle and Postgres on the server, then setup your...
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
August 8, 2008 at 8:31 pm
Are you talking about the About window in SSMS showing the RTM version? Or, are you looking at the connection in Object Explorer? If the latter, then -...
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
August 8, 2008 at 5:26 pm
The only other tool I know about is the SQL Server Health and History tool from Microsoft. It can be downloaded from: http://www.microsoft.com/downloads/details.aspx?familyid=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en
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
August 8, 2008 at 5:16 pm
Review the public role, maybe somebody set explicit deny rights on that role.
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
August 8, 2008 at 3:33 pm
I think this is what you are looking for: http://www.codeplex.com/sqldmvstats/
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
August 8, 2008 at 1:59 pm
Viewing 15 posts - 6,181 through 6,195 (of 6,676 total)