Viewing 15 posts - 21,121 through 21,135 (of 49,552 total)
What about all the necessary registry settings? The the hooks into windows services, etc
Clone the system drive (c drive) and make a new machine out of that might (should even)...
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 11, 2012 at 4:36 pm
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspx
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 11, 2012 at 4:17 pm
Brandie Tarvin (1/11/2012)
GilaMonster (1/11/2012)
Brandie Tarvin (1/11/2012)
GilaMonster (1/11/2012)
My problem is the shipping costs. They start at $60... Maybe next time I'm in going to be in the US I order stuff...
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 11, 2012 at 12:44 pm
Brandie Tarvin (1/11/2012)
GilaMonster (1/11/2012)
My problem is the shipping costs. They start at $60... Maybe next time I'm in going to be in the US I order stuff and have it...
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 11, 2012 at 12:29 pm
Lol.
My problem is the shipping costs. They start at $60... Maybe next time I'm in going to be in the US I order stuff and have it shipped to 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 11, 2012 at 12:23 pm
I want this one: http://www.thinkgeek.com/tshirts-apparel/unisex/frustrations/e718/?srp=2
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 11, 2012 at 12:18 pm
This is not repairable.
Since you have no backups the best you'll be able to do is script out all the objects (some may fail to script due to the corruption),...
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 11, 2012 at 12:00 pm
Please either post a thread in the forums here (this is for discussion of the article, not fixing of a problem), or post a thread over at SQLTeam.
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 11, 2012 at 11:46 am
Jack Corbett (1/11/2012)
2. What's the race condition in 2?
A row could be inserted by someone else between the select and the insert running. Can also counter that...
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 11, 2012 at 10:51 am
P.S. I'll offer the anti-pattern that I've been cleaning out of some procedures recently (comments mine)
DECLARE @count int, @id int
SET @Count = (SELECT count(*) from myTable WHERE Code = @MyCode)...
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 11, 2012 at 9:58 am
Jack Corbett (1/11/2012)
Declare @ids Table (id INT);
IF NOT EXISTS (SELECT * FROM myTable WHERE CODE=@MYCODE)
BEGIN
INSERT INTO myTable (CODE)
...
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 11, 2012 at 9:41 am
azdzn (1/11/2012)
none of those 🙂I would use the 3rd one (EXISTS) at the beginning and get the ID with SCOPE_IDENTITY at the end !
In that case, how would you get...
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 11, 2012 at 9:40 am
In that case, 2 (though I might check if the variable is null or not rather than @@RowCount (which might be affected by triggers), and use Output instead 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 11, 2012 at 9:35 am
Mirroring doesn't need any particular filestream setting. As I said, you can't mirror a DB that has a filestream column in it, so it would be a little weird if...
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 11, 2012 at 9:30 am
Kenneth.Fisher (1/11/2012)
GilaMonster (1/11/2012)
RAID 5 is terrible for logs because...
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 11, 2012 at 9:28 am
Viewing 15 posts - 21,121 through 21,135 (of 49,552 total)