Viewing 15 posts - 5,161 through 5,175 (of 6,486 total)
I saw your questions last night, and...I washed my own mouth out with soap. Table commenting has been a weakness here (actually - that's a misnomer, because that would...
January 18, 2008 at 7:20 am
Unless someone is trying to teach that god-awful four-letter instruction I will not repeat here.
Why someone would ever bring that directive back in, and into SQL Server...
January 18, 2008 at 7:14 am
Cool - that's great Midan. I just didn't want to get YOU in trouble by giving you more than you can "handle". I've been handed those scenarios (having...
January 18, 2008 at 7:09 am
a few quick things:
- first one is - it doesn't have to be RBAR, since it's the same virtual table we've all come to know and love from...
January 17, 2008 at 10:18 pm
Right - there are lots of tools/resources to pull in the basic info/metadata. What doesn't make it in there is the WHAT/WHY/HOW (WHAT should be in the field, WHY...
January 17, 2008 at 8:39 pm
Jeff Moden (1/17/2008)
I wondered when you were going to get to that point...
Ahem - yup. It's that fine line where you want to help someone learn how to swim,...
January 17, 2008 at 8:24 pm
Midan -
No disrespect intended - but I think you ought to take a crack at it. All of the pieces are right there. The reason being -...
January 17, 2008 at 7:34 pm
Try this trick on:
select count(*)-count(col1) as Col1Blank,
count(*)-count(col2) as Col2Blank,
count(*)-count(col3) as Col3Blank,
...
January 17, 2008 at 3:40 pm
I've seen something like it as well when running stuff in SSMS. The time seems to tick well past what it tells me it took to run. So...
January 17, 2008 at 3:21 pm
One issue you're going to have with trying to test for seeks IS the select * (unfortunately:)). It's going to skew your results away from seeks. Also -...
January 17, 2008 at 3:17 pm
Sorry - I've been getting acquainted with them as well.
Look up Common Table Expressions in BOL to get a primer on how they work. Not bad for some...
January 17, 2008 at 2:44 pm
This kind of CTE would do the trick:
With myCTE (nameID, name, address, etc,RN) AS
(
Select MT.nameid,
...
January 17, 2008 at 12:54 pm
GSquared (1/17/2008)
we7313 (1/15/2008)
select dbo.table1.col1, dbo.table1.col2, dbo.table2.col1
from dbo.table1
inner join dbo.table2
on dbo.table1.col3 = dbo.table2.col2
where dbo.table1.col4 = 'widget'
Is serious overkill with no performance gain at all over:
And (like...
January 17, 2008 at 12:39 pm
colin Leversuch-Roberts (1/17/2008)
January 17, 2008 at 12:11 pm
I usually have to declare and pass in a variable to get something back
so - this works for me:
DECLARE @sql nvarchar(1000), @OutputDef nvarchar(1000),@val int
January 17, 2008 at 12:05 pm
Viewing 15 posts - 5,161 through 5,175 (of 6,486 total)