Viewing 15 posts - 5,701 through 5,715 (of 49,552 total)
Alvin Ramard (6/3/2015)
GilaMonster (6/3/2015)
Um...http://www.sqlservercentral.com/Forums/Topic1691210-2799-1.aspx
Crystal ball to aisle 5 please. (or maybe we need something a tad stronger)
Something much stronger is needed here.
I'll pick up some black candles and incense on...
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
June 3, 2015 at 8:45 am
What, other than the NOLOCK hints, is the problem?
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
June 3, 2015 at 8:43 am
Um...
http://www.sqlservercentral.com/Forums/Topic1691210-2799-1.aspx
Crystal ball to aisle 5 please. (or maybe we need something a tad stronger)
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
June 3, 2015 at 8:38 am
Implement *what* in a query?
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
June 3, 2015 at 8:35 am
Alvin Ramard (6/3/2015)
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
June 3, 2015 at 8:30 am
It would help, just a tad, if we had a clue what the definition of the Times table looks like and what the data in it consists 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
June 3, 2015 at 8:28 am
Read the question? What heresy is this, Alvin???
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
June 3, 2015 at 8:11 am
You can't do anything to an index when the database is offline though. Offline database means inaccessible.
I suspect the article means offline as in, don't use the ONLINE = ON...
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
June 3, 2015 at 8:04 am
My general guideline is 'new question -> new thread'.
If I open a thread and notice that the OP is a year old, I probably won't look any further.
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
June 3, 2015 at 6:41 am
You asked how to connect to Management Studio that's running on the server. You don't. You run SSMS locally and connect to the SQL instance from there.
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
June 3, 2015 at 6:22 am
Don't. Run SSMS on your local machine and connect to SQL running on prod.
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
June 3, 2015 at 5:33 am
Follow the debugging in https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
June 3, 2015 at 4:30 am
You'll need to query sys.master_files on each instance to get a list of the mdf and ldf files associated with each instance.
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
June 3, 2015 at 3:57 am
The demo code I used in a recent article.
Setup:
CREATE TABLE Transactions (
TransactionID INT IDENTITY PRIMARY KEY,
TransactionDate DATETIME,
Amount NUMERIC(12,4),
Filler VARCHAR(200)
);
CREATE TABLE Results (
Rows INT,
SumAmount NUMERIC(28,4) -- should now be large enough
);
WITH...
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
June 3, 2015 at 3:36 am
Jacob Wilkins (6/2/2015)
Going back to Gabriel's original question, you don't need NOLOCK to produce duplicate records. As mister.magoo has already shown, you can get duplicate records in READ COMMITTED.
You can,...
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
June 3, 2015 at 3:13 am
Viewing 15 posts - 5,701 through 5,715 (of 49,552 total)