Viewing 15 posts - 7,351 through 7,365 (of 7,619 total)
Lynn Pettis (7/3/2012)
ScottPletcher (7/3/2012)
Also you have 2 very big indexes.One has 10 columns and other has 9 columns .Table just has 12 columns.
It's a pretty sure bet you have the...
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".
July 3, 2012 at 3:45 pm
Also you have 2 very big indexes.One has 10 columns and other has 9 columns .Table just has 12 columns.
It's a pretty sure bet you have the wrong clustered index....
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".
July 3, 2012 at 1:56 pm
Lynn Pettis (7/3/2012)
alter table MyTable
Add Constraint [MyPrimaryKey] Primary Key (MyColumn)
WITH (FILLFACTOR = 75, ONLINE = ON, PAD_INDEX = ON);
Be sure to verify the complete syntax in...
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".
July 3, 2012 at 1:49 pm
During the load in the where clause there is a selection (or join) on the logical key and the row must be actual (Y).
If the logical key nonclus index needs...
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".
June 28, 2012 at 10:25 am
Also, do a
DBCC UPDATEUSAGE
on the table. Heaps seem to report ridiculously incorrect page totals too often for comfort. I've had SQL telling me that a single...
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".
June 28, 2012 at 9:53 am
CELKO (6/27/2012)
ScottPletcher (6/27/2012)
Regarding date formatting, I'd suggest using 'YYYYMMDD', which is foolproof on SQL Server, rather than 'YYYY-MM-DD', which can fail depending on specific settings in SQL Server.
NO! That is...
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".
June 27, 2012 at 4:11 pm
Eugene Elutin (6/27/2012)
Mike John (6/27/2012)
Once committed it is committed....
Not for nested transactions, check this one:
begin transaction outerOne
update Table1 set Col1 = 'booo' where id =1 ...
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".
June 27, 2012 at 3:54 pm
Code looks OK to me.
Regarding date formatting, I'd suggest using 'YYYYMMDD', which is foolproof on SQL Server, rather than 'YYYY-MM-DD', which can fail depending on specific settings in SQL Server.
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".
June 27, 2012 at 3:46 pm
You could have tempdb data files on both RAID1s for performance reasons, simulating something of a faux RAID 10, recoverability obviously not being a factor for tempdb.
Depending on...
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".
June 27, 2012 at 10:34 am
The contention (I think) is where some folks latched onto something you said that implied you knew how to recover from a lost array in a 2xRAID1 setup with no...
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".
June 26, 2012 at 4:58 pm
I think this series of articles is pretty good, and yielded some interesting results about RAID:
http://www.kendalvandyke.com/2009/02/disk-performance-hands-on-part-6-raid.html
That's not to say this article is the last word on RAID or anything. ...
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".
June 26, 2012 at 4:48 pm
Perry Whittle (6/26/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".
June 26, 2012 at 4:26 pm
As I understand it having database files stored across two arrays (data on one array, logs on the other) gives us a better chance of recovering to the point immediately...
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".
June 26, 2012 at 4:07 pm
You lose the db as it exists if a RAID1 fails, but if you place the files properly on the two RAID1s, the db can be fully recovered, which would...
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".
June 26, 2012 at 2:10 pm
You can also use a structure like this:
WHERE 1 = CASE
WHEN @var = A AND [column] IN (A, B) THEN 1
WHEN [column]...
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".
June 26, 2012 at 1:19 pm
Viewing 15 posts - 7,351 through 7,365 (of 7,619 total)