Viewing 15 posts - 6,976 through 6,990 (of 7,613 total)
CELKO (12/28/2012)
For a reasonable level of trust, I use the email address + password, like every website on earth. Seems to work well enough for Paypal, Amazon, et al. People...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 3:40 pm
Sean Lange (12/28/2012)
begin transaction
begin try
-- PART 1 --
Insert into first table
Delete from first table
-- PART 2 --
Insert into a second table
Update my second...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 3:33 pm
You could use an AFTER INSERT trigger to insure that the parent id got set to the identity column values ... but you still couldn't define the parent id as...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 3:19 pm
I would never try to re-run the prod processes to get the data for other environments. That would be a nightmare to keep clean.
One possibility is to mix differential...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 3:08 pm
As noted, heaps are great for "work" / "staging" tables.
Also, I guess in theory a heap could be more efficient for certain types of tables with multiple nonclust indexes, particularly...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 2:40 pm
Sean Lange (12/28/2012)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 1:27 pm
Bhuvnesh (12/27/2012)
Also please post exec plan(people would prefer graphical plan 😛 ) along with index definition too as index play significant role to pull out the data faster.
Agreed....
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 28, 2012 at 10:57 am
SQLRNNR (12/26/2012)
stakes (2/28/2011)
I have a 1T, high I/O database in a SAN environment on which I have planned the database files this way:
L: logfile (8k)
M: mdf file (64k)
N: ndf...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 5:18 pm
Btw, the column data types are not stored in my documentation tables -- I retrieve them at gen time from system views. This adds a little overhead, but insures...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 3:18 pm
Again, if you've got unlimited funds, definitely go RAID10 (or SSD) throughout, but because of the better resiliency, even if pure reads are somewhat slower.
Presumably all of us have done...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 2:02 pm
Used .rtf instead.
The hyperlinks don't work, but it still gives you the flavor.
The underlying html is generated from a table that contains the text documentation.
I'm still working to fully extended...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 11:30 am
Sean Lange (12/26/2012)
ScottPletcher (12/26/2012)
Sean Lange (12/26/2012)
ScottPletcher (12/26/2012)
Sean Lange (12/26/2012)
SQL_Kills (12/26/2012)
First of all I hope everyone has had a good Christmas!
Just wanted to know if anyone documents there table using...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 11:17 am
Sean Lange (12/26/2012)
ScottPletcher (12/26/2012)
Sean Lange (12/26/2012)
SQL_Kills (12/26/2012)
First of all I hope everyone has had a good Christmas!
Just wanted to know if anyone documents there table using MS_Description? I'm struggling...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 10:18 am
It really looks like the column is "char(11)" and not "varchar(11)".
Can you verify the column's data type?
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 9:26 am
Sean Lange (12/26/2012)
SQL_Kills (12/26/2012)
First of all I hope everyone has had a good Christmas!
Just wanted to know if anyone documents there table using MS_Description? I'm struggling to think how...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
December 26, 2012 at 9:10 am
Viewing 15 posts - 6,976 through 6,990 (of 7,613 total)