Viewing 15 posts - 7,306 through 7,320 (of 7,619 total)
You have to use DBCC SHRINKFILE to reduce a file below its initial allocation.
USE <your_db_name>
-- get the file#s / names of all the db's files
EXEC sp_helpfile
Then choose the file# or...
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 19, 2012 at 3:23 pm
Jeff Moden (7/18/2012)
ScottPletcher (7/17/2012)
Sounds like RCS (Read-Committed Snapshot) is what you need here.Why would that be any better than a simple MERGE?
It provides continuous availability of the data, 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".
July 18, 2012 at 8:00 am
SELECT
[Database Name],
[Compression Ratio]
FROM (
SELECT
b.database_name 'Database Name',
...
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 17, 2012 at 3:20 pm
Sounds like RCS (Read-Committed Snapshot) is what you need here.
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 17, 2012 at 12:12 pm
takilroy (7/17/2012)
My intent is to see if anyone has been able to or knows of a way to create a global constant variable or use a sql function to determine...
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 17, 2012 at 11:57 am
I really think you're going to drive people crazy trying to follow this because no one else does it.
Almost universal is to use NULL to mean "no value was passed...
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 17, 2012 at 10:48 am
takilroy (7/17/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".
July 17, 2012 at 9:04 am
Again, in theory yes.
But in the real world that's often difficult to do and takes a lot of time. And often a change later to the code by someone...
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 16, 2012 at 3:42 pm
You can use a lookup table to store default/control values.
Or, less overhead but more obscure, you can store the default/control values in specific byte positions of CONTEXT_INFO.
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 16, 2012 at 3:38 pm
I'm not familiar with MONTHS_BETWEEN, but IF it does always use 31 days as a "month" in that function, then you can get the same result from SQL Server using:
SELECT...
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 16, 2012 at 3:32 pm
Michael Valentine Jones (7/16/2012)
ScottPletcher (7/16/2012)
SQLKnowItAll (7/16/2012)
ScottPletcher (7/16/2012)
Donald Bustell (7/16/2012)
Database: timetracking
Column: project varchar(50)
Questions:
1. What in the world???
2. How would I craft a trigger to just RTRIM everything on the way in?
Thanks
Donald
CREATE...
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 16, 2012 at 3:02 pm
SQLKnowItAll (7/16/2012)
ScottPletcher (7/16/2012)
Donald Bustell (7/16/2012)
Database: timetracking
Column: project varchar(50)
Questions:
1. What in the world???
2. How would I craft a trigger to just RTRIM everything on the way in?
Thanks
Donald
CREATE TRIGGER dbo.project_trg_ins
ON dbo.project
AFTER INSERT
AS
UPDATE...
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 16, 2012 at 2:18 pm
Something like below should do it:
SELECT
CASE WHEN backup_month IS NULL THEN 'ALL'
ELSE LEFT(DATENAME(MONTH, backup_month), 3) END 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".
July 16, 2012 at 2:13 pm
Donald Bustell (7/16/2012)
Database: timetracking
Column: project varchar(50)
Questions:
1. What in the world???
2. How would I craft a trigger to just RTRIM everything on the way in?
Thanks
Donald
CREATE TRIGGER dbo.project_trg_ins
ON dbo.project
AFTER INSERT
AS
UPDATE p
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".
July 16, 2012 at 1:56 pm
JayWinter (7/12/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".
July 13, 2012 at 4:42 pm
Viewing 15 posts - 7,306 through 7,320 (of 7,619 total)