Viewing 15 posts - 46,096 through 46,110 (of 49,552 total)
Sorry, I don't understand what you're asking. Could you explain a bit more please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 7:04 am
Can you run a checkDB on it and post the errors you get?
DBCC CHECKDB ('MSDB') WITH NO_Infomsgs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 7:00 am
Looks like you're trying to attach a SQL 2005 database to a SQL 2000 instance.
Adventure works is SQL 2005, hence can only be attached to SQL 2005 or higher.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 6:15 am
Most likely it will be exactly the same.
A view is just a saved select statement. It doesn't store data at all. When you query a view you are just...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 6:08 am
You mean, if you're lucky, your database comes out of suspect mode. Deleting a log file is like playing russian roulette with your database. You are asking for trouble.
See here...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 6:02 am
I've worked extensivly with profiler in 2000 and 2005. It doesn't limit column width in either version.
Run the following query (substituting the correct table name) and see what it returns.
SELECT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 5:40 am
Michael Earl (6/24/2008)
I do not even think it is possible to see any performance degredation because there is too much in the plan cache.
Pre SP2 on SQL 2005...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 5:32 am
Chris Hall (6/24/2008)
I'll try EXEC xp_servicecontrol 'QueryState', 'SQLServerAgent' too, Gail. That sounds less prone to unexpected name changes!
Maybe, maybe not. I think the second parameter is the service name...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 5:25 am
If you save the profile trace to a file or table, the entire textdata is saved. If saving to a table, the column gets defined as type Text.
Are you only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 5:22 am
Performancewise, I wouldn't think much, if any. Accuracy wise however... Float's an inaccurate data type and prone to rounding errors. It's not something I'd like to store financial values in.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 5:19 am
EXEC xp_servicecontrol 'QueryState', 'SQLServerAgent'
I don't know what permissions are required to run that though. I suspect fairly high.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 5:17 am
You're missing an END on the case
SELECT isnull([PAID],'NO') as [PAID] ,
CASE WHEN isnull(a.[Refill Sales ID],0) = 0 then 'No Refil'
ELSE...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 1:21 am
Should be possible with a case statement. Something like this (partial code only)
SELECT ...
CASE WHEN [Refill ID] IS NULL
THEN 'No REFIL'
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 12:42 am
Could you post the entire error message please? The title gets cut short.
No backup? Why not?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 12:36 am
Gone as in deleted from the operating system? how did that happen?
Do you have a recent backup?
How many log files did the database have?
Was the database detached cleanly from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 12:14 am
Viewing 15 posts - 46,096 through 46,110 (of 49,552 total)