Viewing 15 posts - 47,266 through 47,280 (of 49,552 total)
Rumour also has it that database snapshots may allow what you want, without the need to restore a database at all.
Re filegroups - You can restore individual filegroups in SQL...
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
February 27, 2008 at 11:20 pm
That's a very big question. It depends very much on the circumstances - a user, specific time of day, all the time, random times, etc
I'd start with performance monitor,...
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
February 27, 2008 at 11:20 pm
Manie (2/27/2008)
Howcome it is that I don't know about the event in JHB. How did I miss that one!
You didn't miss much. The MS slides and demos were good,...
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
February 27, 2008 at 10:59 pm
dakshinamurthy (2/26/2008)
Can i uncheck the check box of auto shrink is it okay to do that.
Absolutely. Uncheck it now. Autoshrink should never be enabled on a production server. See...
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
February 27, 2008 at 4:07 am
Free food, free drink and free swag. What's not to like?
I'll be at the JHB launch in about 5 hours.
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
February 27, 2008 at 12:17 am
Check the space available and space on disk for the distribution database.
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
February 27, 2008 at 12:01 am
It's not a stored proc.
ALTER DATABASE <Database name> SET OFFLINE
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
February 26, 2008 at 11:59 pm
Plase don't post multiple threads on the same problem. It wastes people's time and fragments replies.
Replies to the following thread please - http://www.sqlservercentral.com/Forums/Topic460688-146-1.aspx
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
February 26, 2008 at 11:10 pm
It would help if you could give us sample input and desired output. I think I'm still misunderstanding what you have and what you want.
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
February 26, 2008 at 1:34 pm
And the root problem is that you can't use variables to specify the table name. If you want the update to affect different tables depending on the variable, you'll have...
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
February 26, 2008 at 1:10 pm
Couple problems here.
You're missing a join between the two tables SYCFStore s, SYCFSYSTEM sy. Means you'll get a cross join if they have data in them.
The from clause should be...
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
February 26, 2008 at 12:45 pm
If all the rows cast to datetime without an error, then you can ignore that warning and change the data type.
Take a backup of the data first, of course, 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
February 26, 2008 at 12:39 pm
Matt Miller (2/26/2008)
True with one caveat - ORDER BY during an insert would guarantee the values doled out by any Identity field in the destination table.
True. I always forget...
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
February 26, 2008 at 12:36 pm
Rather don't shrink the database. If you truncate the table then the empty space in the DB can be reused by future inserts.
If you shrink the DB, it 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
February 26, 2008 at 12:30 pm
Look up convert. There should be an appropriate style that you can use to convert the date into a datetime. Once it's in a datetime, you can convert it back...
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
February 26, 2008 at 11:53 am
Viewing 15 posts - 47,266 through 47,280 (of 49,552 total)