Viewing 15 posts - 45,001 through 45,015 (of 49,552 total)
Mangle the table names. We don't care if the tables are Table1, Table2, etc
The SQL optimiser is a cost-based optimiser. It generates plans and compares them on the basis of...
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
August 15, 2008 at 10:01 am
Patrick Womack (8/15/2008)
Can someone explain to me how the 'size' in the system view is determined? What does it mean or represent?
According to Books Online:
size: Current size of the...
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
August 15, 2008 at 9:25 am
Ok. Which one are you trying to shrink and what size are you trying to shrink it to?
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
August 15, 2008 at 9:23 am
A few things that may help you get started. Firstly, if you check Books Online, you will see that the syntax for a trigger is as follows:
CREATE TRIGGER < Trigger...
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
August 15, 2008 at 9:14 am
Chad Crawford (8/15/2008)
🙁 I was hoping to learn a new word today!
http://dictionary.reference.com/wordoftheday/
😀
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
August 15, 2008 at 9:09 am
That's for the master database. Please run the query in the database that you are trying to shrink.
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
August 15, 2008 at 9:06 am
gohsiauken (8/15/2008)
CREATE TRIGGER NewSaleItem
AFTER INSERT ON SALEITEM
REFERENCING NEW ROW AS newRow
FOR EACH ROW
AS
That's not SQL syntax. Looks like it might be Oracle. Not sure.
Is this a SQL Server 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
August 15, 2008 at 8:29 am
fixfox8 (8/15/2008)
I can not run right now that query, becaus I am running something else. Thanks.
When you can please post the results. I have a suspicion I know what's...
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
August 15, 2008 at 8:15 am
Who ever said type completely by hand? Management studio can generate all sorts of stubs for queries that are decently formatted and are far faster than typing. (and are fully...
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
August 15, 2008 at 8:13 am
Crispin Proctor (8/15/2008)
I doubt (not sure though) that it is downwards compatible. i.e. attach a 2008 mdf to a 2005 box.
They're not, as expected. Trying to attach a 2008...
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
August 15, 2008 at 8:02 am
Look in the SQL server error log, see if there are any relevant messages in there. Look in the windows application event log for the same.
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
August 15, 2008 at 7:55 am
fixfox8 (8/15/2008)
It is in my question "very large database[/u] file more then 2TB"
Is it a data file (.mdf or .ndf) or a log file (.ldf)
What's the output of the following...
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
August 15, 2008 at 7:54 am
You can connect to a 2005 server from 2008's management studio. The server remains 2005. I'm not sure if you can debug against a lower version. It's one of the...
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
August 15, 2008 at 7:46 am
afgone (8/15/2008)
if i uninstall 2008 would i be able to use 2005
You should be able to. In fact, you should be able to use 2005 anyway. 2005 and 2008 can...
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
August 15, 2008 at 7:43 am
afgone (8/15/2008)
cant remember which one it was. but when starting it says katmai
That would have been one of the CTPs. Any idea how long ago you installed it?
All of the...
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
August 15, 2008 at 6:34 am
Viewing 15 posts - 45,001 through 45,015 (of 49,552 total)