Viewing 15 posts - 33,256 through 33,270 (of 49,552 total)
DECLARE @myVar int
SELECT * FROM myTable
Where Case
WHEN @myVar = 1 THEN
AND myDate > 1/1/2010
...
March 31, 2010 at 9:00 am
Alex V (3/31/2010)
March 31, 2010 at 8:58 am
Pages that have been changed since the snapshot's creation are read from the snapshot (which contains the page as it was before it was modified). Pages that haven't are read...
March 31, 2010 at 3:23 am
So locks are bad, but potentially inconsistent data and incorrect results are OK?
Nolock is not a free lunch, it is not a 'required' hint when querying a production database....
March 31, 2010 at 3:20 am
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/30/2010)
CirquedeSQLeil (3/30/2010)
tosscrosby (3/30/2010)
Paul White NZ (3/30/2010)
WayneS (3/30/2010)
March 31, 2010 at 3:12 am
tom.newman 88696 (3/31/2010)
from table with (nolock)
Why?
March 31, 2010 at 3:10 am
As I posted over at SQLTeam...
If checkDB reports errors it means that it found errors. They may be transient IO errors.
Are you seeing any 825 errors in your error log?...
March 31, 2010 at 1:54 am
Alex V (3/31/2010)
Gentlemen,
I notice this is not addressed to me, but...
What is the value of log_reuse_wait_desc in sys.databases for this database?
What does DBCC OPENTRAN return?
March 31, 2010 at 1:51 am
Yes they do, just like user databases do. There's nothing special about the system databases that will save them from having the IO subsystem mangle their files.
With the system databases...
March 31, 2010 at 1:45 am
keepintouch2b (3/30/2010)
March 31, 2010 at 1:32 am
Beedle (3/30/2010)
From the sound of it you could probably use Case statements.
You can, providing performance is not a major requirement.
March 30, 2010 at 3:11 pm
Yes it is. Beware SQL injection though.
These may be worth reading, just in general, if I understand what you're trying to do.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
March 30, 2010 at 2:55 pm
Cannada
Canadda
Caneda
Canade
Kanada
Canader
March 30, 2010 at 2:52 pm
CirquedeSQLeil (3/30/2010)
Those don't grate on me nearly as much as changing my name.i.e.
Thanks Jase
You're complaining?
You know how many ways there are to misspell either a 4-letter name or a...
March 30, 2010 at 2:43 pm
Viewing 15 posts - 33,256 through 33,270 (of 49,552 total)