Viewing 15 posts - 13,426 through 13,440 (of 49,552 total)
pdanes (4/18/2013)
GilaMonster (4/18/2013)
Eric M Russell (4/18/2013)
April 18, 2013 at 11:42 am
Eric M Russell (4/18/2013)
April 18, 2013 at 11:27 am
Then...
GilaMonster (4/18/2013)
April 18, 2013 at 11:12 am
curious_sqldba (4/18/2013)
Paul Randal (4/18/2013)
It used to take table locks in 7.0 - from 2000 onwards it's been online by default, with no table locks.
Thanks Paul. If DBCC doesn't place any...
April 18, 2013 at 10:57 am
In summary, incorrect data. Not dirty reads, missing rows and duplicate rows. You can read entire chunks of data twice (or more). You can miss entire chunks of rows.
Fine for...
April 18, 2013 at 10:52 am
Thanks. Post corrected accordingly (I never worked with SQL 7)
April 18, 2013 at 10:49 am
Dree Vasquez (4/18/2013)
I don't think it is correct to grant everyone db_owner privileges.
No, absolutely not. Principal of minimal privileged. Users don't need to be able to drop the database, delete...
April 18, 2013 at 8:39 am
To be bluntly honest, comma-delimited lists are a hint that the table design isn't right. Why a comma-delimited list in a column and not a child table with one row...
April 18, 2013 at 8:24 am
Brandie Tarvin (4/18/2013)
GilaMonster (4/18/2013)
Forum points: A measure of how much time is spend not doing productive work.
Hey! This is productive. (SET @PompousVoice = ON) I'm building my brand and borrowing...
April 18, 2013 at 8:07 am
Preet_S (4/18/2013)
The optimiser will NOT use a plan for one query for another query.)
Agreed, my misunderstanding. Except in the case of Parameter Sniffing.
No exceptions. Parameter sniffing is the same...
April 18, 2013 at 8:06 am
Forum points: A measure of how much time is spend not doing productive work.
April 18, 2013 at 7:39 am
Yes.
With the automated one, creating partitions happens and you'll never run out of partitions (unless the job fails) and you keep to a minimum the number of partitions that SQL...
April 18, 2013 at 7:33 am
Cool. Just bear in mind that performance gains are not automatic.
I'd suggest option 1. You don't have to (and in fact shouldn't) do the split/merge manually, have a job that...
April 18, 2013 at 7:07 am
What's the goal here? Why are you considering partitioning?
April 18, 2013 at 6:55 am
The Comedian (4/18/2013)
CREATE NONCLUSTERED INDEX INDEX_Q1_Employee ON Employee(EmploymentStatus ASC,
LastName ASC,
FirstName ASC)
INCLUDE (Company, Department)
CREATE NONCLUSTERED INDEX INDEX_Q1_People ON People(
Profession ASC,
LastName ASC,
FirstName ASC)
INCLUDE (Age, Address)
Yes, those are much better and they'll work...
April 18, 2013 at 6:34 am
Viewing 15 posts - 13,426 through 13,440 (of 49,552 total)