Viewing 15 posts - 19,516 through 19,530 (of 49,552 total)
Please don't cross post. It just fragments replies and wastes people's time
No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1274059-391-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
March 28, 2012 at 5:40 am
One guideline I strongly disagree with...
Avoid Nonclustered, Unfiltered Indexes on Columns that have few Distinct Values
The old cliché is “Never index the Gender column”. A typical page 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
March 28, 2012 at 2:17 am
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
March 28, 2012 at 2:12 am
my question is if we run the sp_repldone on db will it create any other issues like log agents will not pick ?
If you have snapshot replication then you don't...
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
March 28, 2012 at 2:09 am
bala2 (3/28/2012)
can any one help me out here..what analaysis i have to specify to client.
No idea, what does the client want to know?
If you have no idea where 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
March 28, 2012 at 2:08 am
SQLKnowItAll (3/27/2012)
GilaMonster (3/27/2012)
SQLKnowItAll (3/27/2012)
Also, the (+) is something I have never seen.
Same as SQL's old join syntax. Table1.Column1 *= Table2.Column2. Oracle syntax is Table1.Column1 (+)= Table2.Column2
sysdate is the Oracle function...
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
March 27, 2012 at 3:33 pm
Scott Solice (3/27/2012)
Jared, Thanks. The + just concatenates the character values, PL/SQL uses || so I get the things like that.
Jared's refering to this line:
vol.subclient(+) = calc.subclient and vol.full_queue(+) =...
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
March 27, 2012 at 3:15 pm
SQLKnowItAll (3/27/2012)
Also, the (+) is something I have never seen.
Same as SQL's old join syntax. Table1.Column1 *= Table2.Column2. Oracle syntax is Table1.Column1 (+)= Table2.Column2
sysdate is the Oracle function to return...
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
March 27, 2012 at 3:10 pm
master's recovery model is always simple, regardless of what the actual database setting value is set to. It cannot ever have log backups taken or restored
Re log backups for...
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
March 27, 2012 at 2:31 pm
Rod at work (3/27/2012)
As you suggest, our database schema doesn't change that frequent, so I could turn back the system database backup files to once or twice a week.
Nothing 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
March 27, 2012 at 1:34 pm
The Dark Passenger (3/27/2012)
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
March 27, 2012 at 11:50 am
Rod at work (3/27/2012)
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
March 27, 2012 at 11:48 am
Huh? Don't understand.
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
March 27, 2012 at 11:42 am
Lynn Pettis (3/27/2012)
GilaMonster (3/27/2012)
Lynn Pettis (3/27/2012)
Aty01 (3/27/2012)
there is no link to order table
Stepping in a minute. Look at your Order table and think of an order you may 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
March 27, 2012 at 11:35 am
Aty01 (3/27/2012)
orders belong to a customer
Which you already have handled since the Orders table has a foreign key to customers.
Right, next thing... Look at these two entities
Order
Order Date
product description
price
qty ordered
Reference...
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
March 27, 2012 at 11:35 am
Viewing 15 posts - 19,516 through 19,530 (of 49,552 total)