Viewing 15 posts - 5,371 through 5,385 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 25, 2011 at 2:04 pm
Please be more specific.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 25, 2011 at 1:55 pm
Can you post the actual execution plans to the thread?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 25, 2011 at 10:49 am
Lowell (7/25/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 24, 2011 at 8:53 pm
Jeff Moden (7/23/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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.
Bidirectional Transactional Replication
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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?...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 23, 2011 at 3:44 pm
Bah! SELECT INTO! 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 23, 2011 at 3:18 pm
Not a problem Jeff. Here is how I got there:
Build a Tally table to facilitate building of MyList with 400K rows:
USE tempdb
GO
-----------------------------------------------------------------
-- Build Tally table.
-- Script credit: http://www.sqlservercentral.com/scripts/Advanced+SQL/62486/
IF EXISTS...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 23, 2011 at 3:09 pm
Viewing 15 posts - 5,371 through 5,385 (of 7,164 total)