Viewing 15 posts - 316 through 330 (of 492 total)
Carlton Leach (11/7/2010)
TBH, I take SSC ratings about as seriously as MS certs 😀
6.5? You poor scarred soul, I hear the dentist is far more pleasant
A man after my won...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 7, 2010 at 4:46 pm
I'd go for a mix of option 1 & 3.
You can create the table with the identity column defined, but with both SSIS and BCP you can "enbale identity insert"....
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 7, 2010 at 3:16 pm
Carlton Leach (11/5/2010)
But his SSC.com rating is higher than yours Mr Miller, I was trying to have a little faith 😉
What's with the Mr Miller? Makes me feel like...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 7, 2010 at 2:51 pm
Lowell (11/4/2010)
He may not be familiar with sp_help [TableName]...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 4, 2010 at 1:44 pm
homebrew01 (11/4/2010)
Carlton Leach (11/4/2010)
This must be a pi$$ takeOr a troll
I don't think so. I looked at the users previous posts (click on the user, select "Find all member's posts")...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 4, 2010 at 1:14 pm
raistlinx (11/3/2010)Depending on what kind of a RAID environment you may be working in (often beyond your control) it can take a lot longer than that. So let's suppose...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 3, 2010 at 2:40 pm
raistlinx (11/3/2010)
Because of the time it takes to create a new clean DB. Often times in developement you may want to clean out the tables quickly to have a fresh...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 3, 2010 at 1:34 pm
HoustonFirefox (11/1/2010)
.....
Why can't...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 1, 2010 at 3:53 pm
Probably SQL is using a cached query plan. Try doing a DBBC DROPCLEANBUFFERS.
Note that this may impact performance while new query plans are built and cached. You can get the...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 1, 2010 at 3:12 pm
I would almost never use DB Snapshots for reporting, there are a lot of better options and a lot of restictrions with snapshots.
Far better to use replication. This allows you...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 20, 2010 at 6:28 pm
Tara-1044200 (10/20/2010)
So far i used to restore all databases onto development but i dont want to continue this anymore due to the time involved.
How often are you doing this and...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 20, 2010 at 2:23 pm
Raghavender (10/18/2010)
Yes, we did that but no use.We have set up the Profiler, but no use.
This doesn't make sense, if you put a filter on the table and select the...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 19, 2010 at 5:30 pm
The execution plan won't return any user data, at most it will return some tables and index info.
Also seeing the code for the underlying view makes a big difference. They...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 19, 2010 at 4:49 pm
sqldba_icon (10/19/2010)
pavan_srirangam (10/19/2010)
Run both queries and include exec plans and see you will find...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 19, 2010 at 2:47 pm
Nullable columns can cause problems for queries like this. NULL is an undefined value, think of it as "noise". This means SQL can't do an EQUALS test on it. To...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 19, 2010 at 2:28 pm
Viewing 15 posts - 316 through 330 (of 492 total)