Viewing 15 posts - 1 through 15 (of 7,618 total)
You can create a standard SQL alert that is based on the db size (in KB) exceeding whatever amount you specify.
In SQL Server Agent; "Alerts"; "New Alert"; "SQL Server performance...
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".
August 23, 2026 at 9:46 pm
Interesting q. No, haven't done that.
I guess easiest would be to use a subquery, which you're already familiar with, so that's not what you're looking for, but just to be...
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".
August 19, 2026 at 3:33 pm
Definitely use new VMs. Too many installation settings could matter here. The new VM approach also allows you to test with a db to two without having to wait for...
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".
August 19, 2026 at 2:08 pm
No, I don't think you would. I don't think TEXTIMAGE_ON clause is allowed is a partition scheme is used (based on MS documentation). Sorry, I don't have time to test...
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".
August 12, 2026 at 2:46 pm
Don't need IIF, just standard WHERE NOT:
WHERE NOT (Customer between 99202 and 99215 and State = 'NY')
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 14, 2026 at 7:30 pm
Sounds like you could use a SEQUENCE. For example:
CREATE SEQUENCE dbo.bom_sequence AS int START WITH 9000000 INCREMENT BY 1 NO CYCLE ;
SELECT CASE WHEN item_number = ''...
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 17, 2026 at 6:46 pm
A leading datetime clustering key would not be a problem at all, i.e., there's no reason to exclude a datetime from a clustering key. As you, and others, have noted,...
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".
May 21, 2026 at 4:21 pm
Hmm, it would have been best to put a data change capture in place before the mods occurred. If the mods aren't too long and you can go back to...
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".
April 22, 2026 at 8:52 pm
Something like this should do it:
DECLARE @date date;
SET @date = GETDATE();
SELECT CONVERT(varchar(8), @date, 112) AS DateKey, StorageTier,
COUNT(DISTINCT FileId) AS FileCount, SUM(SizeBytes) 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".
April 8, 2026 at 6:06 pm
Performance wise, you don't want the db to contain more than 5,000 to 6,000 tables when using that script.
To limit the tables to process, specify a different table name pattern:
...
SET...
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".
March 5, 2026 at 11:24 pm
There is no automatic formula that can do this analysis for you, it has to be done by a knowledgeable person.
If you have a critical table(s) you want reviewed, post...
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".
March 5, 2026 at 11:22 pm
For clarity, and potentially accuracy for more complex "OR" conditions, I suggesting another set of parentheses:
WHERE
((@Type = 'AB' AND PlanDescription IN ('DEF','GHI')) OR
(@Type = 'CD' AND PlanDescription IN ('UVW','XYZ'))
)
Yes, the original...
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".
February 16, 2026 at 10:01 pm
What table is vision_flag in? Helps for others to follow your code if you use aliases for table and then ALWAYS add an alias for every column name used 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".
February 6, 2026 at 10:06 pm
> 3 columns (2 int and 1 bigint) <
This could be a (rare) case where partitioning is a good idea; partitioning being based on one/both of the 2 int leading...
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".
January 28, 2026 at 12:19 am
Actually, none of the suggested code, since you should always specify NULL or NOT NULL when ADDing columns to be sure you get the specific setting you want.
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".
January 21, 2026 at 7:22 pm
Viewing 15 posts - 1 through 15 (of 7,618 total)