Viewing 15 posts - 4,081 through 4,095 (of 15,381 total)
patrickmcginnis59 10839 (7/30/2014)
...
If its a fish, why are the solutions still working? Shouldn't they only have lasted the extent of a single meal?
Sorry to jump in at this late point,...
July 30, 2014 at 12:42 pm
ScottPletcher (7/30/2014)
Sean Lange (7/30/2014)
ScottPletcher (7/30/2014)
Keith Tate (7/30/2014)
What can happen if null is not defined?
If you don't set the NULL option then it will be nullable.
create table Test1 (ExpirationDate datetime);
go
That's not...
July 30, 2014 at 10:17 am
rajsin7786 (7/30/2014)
hi sean,sales_fact has 1 billion records, other 3 tables have less than 100K records
That is how many rows, not the amount of movement. The reason I ask is looking...
July 30, 2014 at 10:13 am
rajsin7786 (7/30/2014)
Hi, the stats were run 3 weeks back. i have attached the create table scripts for 4 tables. will paste the index soon.
How much data movement is in...
July 30, 2014 at 10:03 am
ScottPletcher (7/30/2014)
Keith Tate (7/30/2014)
What can happen if null is not defined?
If you don't set the NULL option then it will be nullable.
create table Test1 (ExpirationDate datetime);
go
That's not true. The...
July 30, 2014 at 10:03 am
JoseACJr (7/30/2014)
During the installation of SQL Server or even once installed, can we define default value for some types (eg DateTime) for all tables...
July 30, 2014 at 9:29 am
SQLRNNR (7/30/2014)
Sean Lange (7/30/2014)
SQLRNNR (7/30/2014)
Sean Lange (7/30/2014)
Lynn Pettis (7/30/2014)
July 30, 2014 at 8:52 am
Grant Fritchey (7/30/2014)
Sean Lange (7/30/2014)
Grant Fritchey (7/30/2014)
I would never suggest we denormalize our structures in most normal situations...
July 30, 2014 at 8:48 am
SQLRNNR (7/30/2014)
Sean Lange (7/30/2014)
Lynn Pettis (7/30/2014)
July 30, 2014 at 8:43 am
Grant Fritchey (7/30/2014)
Sean Lange (7/29/2014)
Actually normalization (more tables) causes slower performance.
I want to let this go, but I just can't.
No. Not true.
Everything, everything, within a structured storage engine comes...
July 30, 2014 at 8:36 am
Lynn Pettis (7/30/2014)
July 30, 2014 at 8:25 am
Actually normalization (more tables) causes slower performance. That is the nature of the beast. However, in a relational database such as this you want to normalize. When designing your data...
July 29, 2014 at 3:12 pm
Greg Edwards-268690 (7/29/2014)
The Dixie Flatline (7/29/2014)
SQLRNNR (7/29/2014)
bantrim (7/29/2014)
This isn't a water cooler. This is a 24 hour all-you-can eat buffet with hard liquor and amphetamines.
:hehe::-D
That's funny
All great humor is...
July 29, 2014 at 9:19 am
JunkIt (7/29/2014)
As for the "why", this is a data...
July 29, 2014 at 8:20 am
Wow talk about sparse on details. It is hard to figure out what you are trying to do here. You really need to read up on normalization. You should NOT...
July 29, 2014 at 8:11 am
Viewing 15 posts - 4,081 through 4,095 (of 15,381 total)