Viewing 15 posts - 8,686 through 8,700 (of 49,571 total)
How would multiple dates be passed?
What happens if the multiple dates aren't in chronological order? (1 May 2014, 2 December 2013, 16 March 2014)?
June 18, 2014 at 5:50 am
No.
The estimated execution plan can give you the estimated number of rows, but that could be exactly correct, slightly wrong or several miles out depending on a large number of...
June 18, 2014 at 5:41 am
ravi.teja 62048 (6/18/2014)
CREATE TRIGGER caseid_increment_trigger BEFORE INSERT ON ecaseFOR EACH ROW SET NEW.case_id = (select ifnull(max(case_id),9999) + 1 from ecase where project_id = new.project_id);
That's not a SQL Server trigger (SQL...
June 18, 2014 at 3:52 am
Multiplication and division have the same precedence, so in the absence of brackets it will be run exactly as written, take a, divide it by b, multiply the result by...
June 18, 2014 at 3:50 am
Rebuilding indexes will cause the DB to grow if there's not enough free space. This isn't an issue, this is normal behaviour. Fill factor should be based on usage patterns,...
June 18, 2014 at 3:13 am
BWFC (6/18/2014)
GilaMonster (6/18/2014)
Koen Verbeeck (6/18/2014)
The question clearly states that the databases are on site. Thus, by the process of elimination, the corruption answer is the only one...
June 18, 2014 at 3:00 am
Koen Verbeeck (6/18/2014)
The answer is incorrect.The question clearly states that the databases are on site. Thus, by the process of elimination, the corruption answer is the only one left.
Except corruption...
June 18, 2014 at 2:36 am
For this you probably want to buy a 3rd party monitoring tool. It'll be the fastest and easiest. Is there budget?
June 18, 2014 at 2:29 am
Also
kapil_kk (6/18/2014)
select cast(@date as varchar)
Don't declare or cast varchars without a length definition. The default will bite you sooner or later.
June 18, 2014 at 1:32 am
Messages are a client application concern. SQL doesn't really have the ability to send custom notifications to users.
June 18, 2014 at 1:28 am
free_mascot (6/17/2014)
June 18, 2014 at 1:25 am
Please post table definition, index definitions, the trigger's definition and the deadlock graph (xml from system health or output from traceflag 1222)
June 18, 2014 at 1:21 am
rhythmk (6/17/2014)
sugnu iu (6/17/2014)
dev environment
So are you ok with dropping a table having 90 million records from any environment ? Think of the scenario when you are working on some...
June 18, 2014 at 1:18 am
SQLRNNR (6/17/2014)
GilaMonster (6/17/2014)
SQLRNNR (6/17/2014)
The Dixie Flatline (6/17/2014)
GilaMonster (6/17/2014)
"No pressure to...
June 18, 2014 at 1:11 am
SQLRNNR (6/17/2014)
The Dixie Flatline (6/17/2014)
GilaMonster (6/17/2014)
"No pressure to work overtime"...
June 17, 2014 at 4:48 pm
Viewing 15 posts - 8,686 through 8,700 (of 49,571 total)