Viewing 15 posts - 29,086 through 29,100 (of 49,552 total)
It would be a very bad design. Constraints belong in the database and data should be constrained as much as possible (data types, foreign key + check constraints)
If you're worrying...
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
December 1, 2010 at 8:36 am
SwayneBell (12/1/2010)
but " getdate() - 30" does not subtract 30 days, it subtracts 30 seconds or milliseconds.
It subtracts 30 days. A 30 sec test would have shown that.
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
December 1, 2010 at 8:33 am
If the column cannot contain nulls, make it NOT NULL.
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
December 1, 2010 at 8:27 am
alen teplitsky (12/1/2010)
looking at the range scans i see there is data in the table from 6 months ago
For the security log?
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
December 1, 2010 at 8:22 am
I don't believe that's possible. Those are two different versions of SQL. It's like trying to mirror SQL 2008 to SQL 2005.
The only time mirroring with different versions is...
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
December 1, 2010 at 8:04 am
Mistake in the code? Without seeing the code, there's not really much that can be said.
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
December 1, 2010 at 7:38 am
No. when you ship the logs, you ship all modifications that were made.
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
December 1, 2010 at 7:29 am
WayneS (12/1/2010)
Chris Morris-439714 (12/1/2010)
WayneS (11/30/2010)
To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!
Good Lord Wayne you're morphing...
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
December 1, 2010 at 7:04 am
Brandie Tarvin (12/1/2010)
And now we know why the Project from Hell has been pushed back. @=)
I wish it were that logical. Business user (person screaming for app for months) is...
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
December 1, 2010 at 6:30 am
You know there's a problem when...
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
The Chief Enterprise Architect
...
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
December 1, 2010 at 6:11 am
Post code.
You probably didn't check @@Error correctly. It needs to be checked after every statement. Since you're on SQL 2005, rather use TRY ... CATCH
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
December 1, 2010 at 4:46 am
Ninja's_RGR'us (12/1/2010)
InfiniteError (11/30/2010)
------It's strange how the most disturbing and important post of this thread just disappears at the same time that 3rd party app post appears here!
Good thing Arjun quoted...
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
December 1, 2010 at 4:44 am
Have you looked in Books Online?
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
December 1, 2010 at 1:03 am
InfiniteError (11/30/2010)
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
November 30, 2010 at 10:46 pm
Trey Staker (11/30/2010)
I did something years and years ago self joining a table on an key field that looked similar to what Gus wrote.
I've done that, for a T-SQL (christmas)...
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
November 30, 2010 at 2:58 pm
Viewing 15 posts - 29,086 through 29,100 (of 49,552 total)