Viewing 15 posts - 8,686 through 8,700 (of 49,552 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)?
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
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...
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
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...
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
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...
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
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,...
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
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...
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
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...
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
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?
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
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.
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
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.
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
June 18, 2014 at 1:28 am
free_mascot (6/17/2014)
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
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)
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
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...
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
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...
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
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"...
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
June 17, 2014 at 4:48 pm
Viewing 15 posts - 8,686 through 8,700 (of 49,552 total)