Viewing 15 posts - 48,016 through 48,030 (of 49,552 total)
DTS. Fast load and limit the number of rows in each batch.
If possible, switch to bulk-logged mode before and switch back to full (and take a full DB backup) once...
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 17, 2007 at 1:53 pm
Since you're using SQL 2005, look up Pivot in books online.
Does exactly what you're looking for.
p.s. Why the restriction on not using temp tables, functions, etc?
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 17, 2007 at 5:32 am
The reason he got the error is, as I mentioned above, due to the subquery only working if there is 1 row in it. It's due to the equality.
The...
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 17, 2007 at 5:29 am
sven.blackwood (12/16/2007)
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 17, 2007 at 1:28 am
Take a look at SQL profiler. There are counters for object access. Be warned, they are fairly high-frequency events, so you'll get lots and lots of trace data.
If you go...
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 17, 2007 at 1:26 am
Than rather move the contents of the stored proc into the trigger, so you don't have to call the proc for each updated row, but can operate on all rows...
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 16, 2007 at 11:59 am
If they're on the same LUN, not much. You'll only see a real performance gain (in physical IO speed) if the files are on separate LUNs
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 16, 2007 at 5:36 am
WILLIAM MITCHELL (12/15/2007)
So according to MS, the app devs don't need to know anything about the database.:sick:
Personally, I'd rather they didn't, and asked people who do to write them the...
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 16, 2007 at 5:27 am
Is the column in question the first column in that composite index? If yes, an index on it alone will be redundant. If no, then create it.
I'll second the comment...
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 16, 2007 at 5:13 am
Do you have any linked servers defined? If so, using what drivers?
I've encountered a number of memory leaks and memory scribbling coming from a DB2 driver (IA64 version)
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 14, 2007 at 2:50 pm
TaffyLewis (12/14/2007)
select t1.A, t1.C, t2.C
from t1 inner join t2
on t1.A = t2.A
and t1.C = t2.C
t2.c is the date field
t1.C and t2.C are the same values. Your join assures 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 14, 2007 at 2:48 pm
This is the problem line (or at least the main problem)
Stephen Lee (12/14/2007)
SET @CustomerID = (SELECT CustomerID FROM INSERTED)
If that select returns more than one row (which will happen if...
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 14, 2007 at 1:00 pm
The exam wasn't that bad. Much easier than I was expecting. Easier than 441 or 442.
It's pretty much the same format as the other ITP exams. No major surprises. It...
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 14, 2007 at 12:34 pm
Adam Haines (12/14/2007)
GilaMonster is this in the wrong thread?
*sigh* I keep getting posts in the wrong threads when I'm replying to 2 or more at a time. Isn't consistent and...
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 14, 2007 at 9:10 am
One piece of advice I will offer you, based on some recent experience conducting interviews.
Leave the arrogance at home. It's the fastest way to end an interview. Be confident, yes,...
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 14, 2007 at 9:06 am
Viewing 15 posts - 48,016 through 48,030 (of 49,552 total)