Viewing 15 posts - 26,701 through 26,715 (of 49,552 total)
HowardW (4/15/2011)
I seem to remember most of the 6 month trial's of SQL Server are the Enterprise Edition.
Under the covers, yes, but they are called Evaluation Edition. Evaluation edition should...
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
April 15, 2011 at 3:50 am
Why are you installing Enterprise edition? Are you aware that you will have to license that, as per the enterprise edition costs (and they are not cheap)?
Developer edition installs fine...
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
April 15, 2011 at 3:40 am
Raghavender (4/14/2011)
Now the question is will the new transactions will enterinto 6th file or it will try to share the data between 6 files?
Depends. Are they all 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
April 15, 2011 at 3:37 am
I thought those were simplifications
The insert trigger is unnecessary. Set defaults on the columns and SQL will set the values for you without a trigger. The update trigger should 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
April 15, 2011 at 3:18 am
There's a comma before the AS where it shouldn't be.
USE Master
GO
CREATE DATABASE AdventureWorks_snap021607 ON
(NAME = AdventureWorks_Data, FILENAME = 'C:\AdventureWorks_data_021607.ss' ),
(NAME = fg0103SALES , FILENAME = 'J:\AdventureWorks_FileGroups\FG0103SALES\0103SALES.ndf'),
(NAME = fg0406SALES , FILENAME...
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
April 15, 2011 at 2:46 am
Fal (4/15/2011)
Sadly, you left out the old Bait n Switch. This happened to me a few years...
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
April 15, 2011 at 2:41 am
Post the trigger code. Triggers should not have major impacts, if they do, there's likely something wrong, but it's impossible to be specific without seeing the trigger definition.
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
April 15, 2011 at 2:32 am
1) Depends on your downtime and data loss allowance (RTO and RPO SLAs). In short, you need a backup strategy that will allow you to meet them. Find out what...
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
April 15, 2011 at 12:00 am
Please post new questions in a new thread. That's not the same error the OP had.
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
April 14, 2011 at 11:51 pm
They don't move. Data does not move from the log to the data file.
When a transaction occurs the data page is changed in memory and the log record is written...
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
April 14, 2011 at 2:00 pm
slaberer (4/14/2011)
The main reason for disabling/enabling the triggers is simply the fact that they caused some performance issues. disabling them did away with it.
I'd probably tune the triggers first.
If...
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
April 14, 2011 at 8:01 am
http://www.sqlservercentral.com/stairway/72363/
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
April 14, 2011 at 7:46 am
I actually find it easier. All the column names on the line above where I'm typing the values or select (i put all on columns on one line, all values...
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
April 14, 2011 at 7:27 am
a648 (4/14/2011)
It make me cringe to specify columns and value in two separate lists like this
Why? That's standard SQL syntax used by all relational database systems.
Insert into table (column...
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
April 14, 2011 at 7:00 am
Grant Fritchey (4/14/2011)
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
April 14, 2011 at 6:26 am
Viewing 15 posts - 26,701 through 26,715 (of 49,552 total)