Viewing 15 posts - 20,971 through 20,985 (of 49,552 total)
I like deploying to MSDB, but the packages are in source control (zipped, some systems mess them up if the store them as XML)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 7:40 am
PaulB-TheOneAndOnly (1/17/2012)
1- If you are deleting the whole table please use truncate rather than delete. Truncate will do it instantly and generate no t-log.
Minimal transaction log activity, not none. Truncate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 7:24 am
It's not recursive. sys.objects$ is some hidden internal view, I've looked for its definition but I've never been able to dig it out.
The best I've been able to get (DAC...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 7:19 am
Also note that narrow indexes may well be useless - not used by SQL because they are not selective and not covering - and so you lose on both counts,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 6:01 am
Just note that seeing a seek in a plan does not necessarily mean it's an efficient seek. Check what's been evaluated as a seek predicate (what SQL navigates the b-tree...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 6:00 am
I thought I'd do some quick testing. SQL 2008 SP3. AdventureWorks DB.
CREATE PROCEDURE SearchHistoryCase
(@Product int = NULL, @OrderID int = NULL, @TransactionType char(1) = NULL, @Qty int = NULL)
AS
SELECT ProductID,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 5:30 am
Rayven (1/17/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 5:13 am
Here you go...
http://www.red-gate.com/products/sql-development/sql-source-control/
Aside. Developing directly on the production server is one hell of a risk. Sooner or later a miss-type or other similar happening is going to cause major problems...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 4:54 am
Personally I just find it hilarious that the US denounces that kind of censorship in China and Iran, then considers implementing it at home. "Do what I say, not what...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 4:46 am
You certainly can script individual indexes. From Object Explorer expand out the table, right click on the index (under the table -> indexes) and select script.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 4:42 am
No, just that the tools don't usually script indexes when you ask for the table to be scripted. It can be a separate option, depending how you did the script.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 4:29 am
SQLRNNR (1/17/2012)
SQL Kiwi (1/17/2012)
Perhaps SSC should go dark too. Or just the 'getting worse' questions 🙂Maybe twitter too?
Well, seeing as the twitter CEO tweeted that wiki's actions is foolish,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 4:25 am
Unless the backup was taken WITH CHECKSUM, a restore verifyonly just checks the backup header and some metadata. It's entirely possible for a backup to verify but not restore.
If the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 4:21 am
Brigadur (1/17/2012)
I think it must put an incredible pressure on tempdb as all the temporary objects are created there also and there is only one tempdb per instance.
No. Pressure, yes,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 3:15 am
Unless you're talking about indexes on hundreds of byte-wide char columns, for three indexes size should not be a concern. In general, one would go for a smaller number of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2012 at 3:13 am
Viewing 15 posts - 20,971 through 20,985 (of 49,552 total)