Viewing 15 posts - 6,991 through 7,005 (of 7,619 total)
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
Lynn Pettis (12/25/2012)
ScottPletcher (12/25/2012)
Lynn Pettis (12/24/2012)
ScottPletcher (12/24/2012)
If you're...
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 25, 2012 at 1:47 pm
Lynn Pettis (12/24/2012)
ScottPletcher (12/24/2012)
If you're going to put...
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 25, 2012 at 1:38 pm
SSRS will automatically properly expand an "IN (@multi_valued_report_parameter)" if it's in an SSRS dataset and follows some basic rules. You may want to verify that you have a proper...
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 24, 2012 at 10:00 am
SELECT
CAST(DATEDIFF(SECOND, Start.WorkQueueStartWorkDate, Finish.WorkQueueEndWorkDate) / 3600 AS varchar(3)) +
RIGHT(CONVERT(char(8), Finish.WorkQueueEndWorkDate - Start.WorkQueueStartWorkDate, 8), 6)
from (
select CAST('20121216 20:57:01.293' 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 24, 2012 at 9:57 am
Let's assume you can get all that information.
You have conflicting needs: you don't want to slow down the login process, but you also don't want to store full string descriptions...
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 24, 2012 at 9:36 am
You also need to verify that the log LUNs are RAID10 and the data LUNs are RAID5 (typically that is the best performance).
If you're going to put both tempdb mdf...
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 24, 2012 at 9:31 am
SQLSACT (12/19/2012)
Why does the 1st query return duplicates and the 2nd query doesn't?
... the 2nd query having a stream aggregate. Why is this being added?
Thanks
The first query does a JOIN;...
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 21, 2012 at 2:52 pm
Don't see anything magical to let you get rid of any of the lookup joins :-).
There typically won't be, so all you can do is tune the lookups as much...
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 21, 2012 at 2:11 pm
If you do need a prefix (and/or suffix), you can do this:
CREATE TABLE dbo.tablename (
prefix char(3) DEFAULT 'ABC',
ident int IDENTITY(1, 1) NOT...
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 21, 2012 at 1:34 pm
Viewing 15 posts - 6,991 through 7,005 (of 7,619 total)