Viewing 15 posts - 5,371 through 5,385 (of 7,168 total)
SQLRNNR (7/26/2011)
That's cool. For the record - I was just teasing.:hehe::hehe::hehe:
😎 Cool, just giving you due credit, I was not trying to bypass it in my earlier post, just...
July 26, 2011 at 9:34 am
SQLRNNR (7/26/2011)
opc.three (7/26/2011)
DIB IN (7/26/2011)
This above article defines to estimate table size based on table structure and number of estimated records for the table.
While estimating a table size I found...
July 26, 2011 at 9:11 am
DIB IN (7/26/2011)
This above article defines to estimate table size based on table structure and number of estimated records for the table.
While estimating a table size I found that...
July 26, 2011 at 7:50 am
Jason, Lowell, note the OP said "estimate". Your solutions are geared towards already existing tables.
DIB IN, please clarify what you're looking for.
July 25, 2011 at 2:15 pm
Anytime. The drop in performance when removing a data type mismatch is odd. I cannot even venture a wag as to why that might have occur.
It's not of much consequence...
July 25, 2011 at 2:04 pm
Can you post the actual execution plans to the thread?
July 25, 2011 at 10:49 am
Lowell (7/25/2011)
July 25, 2011 at 10:19 am
Tess-205818 (7/25/2011)
- The stored procedure Owner is dbo.
- All the tables have the Owner as dbo.
- The audit tables...
July 25, 2011 at 10:01 am
mitch.fh (7/25/2011)
WHERE name COLLATE Latin1_General_100_BIN LIKE N'[A-Z]%' ;
Hi,
COLLATE to BIN works fine.
I guess it is not quite a performance-booster to change the collation while using LIKE.
Are you saying...
July 25, 2011 at 6:18 am
According to Books Online LIKE is implemented per the ISO standards when it comes to Unicode data:
It also says Collations can affect results. I think I found a workaround...
July 24, 2011 at 8:53 pm
Jeff Moden (7/23/2011)
July 23, 2011 at 6:08 pm
Your questions are very general. Have a look at Books Online. It has all the information you need.
July 23, 2011 at 4:52 pm
fsnell (7/23/2011)
CELKO (7/23/2011)
Basic Netiquette is to post DDL; read the section at the start of the Forum.
What is DLL? Read what section at the start of Forum?...
July 23, 2011 at 4:40 pm
Jeff, I think you may have finally ended the long run my old [default] habit was on once and for all 😉
Thanks as always!
July 23, 2011 at 3:44 pm
Viewing 15 posts - 5,371 through 5,385 (of 7,168 total)