Viewing 15 posts - 4,291 through 4,305 (of 49,552 total)
MotivateMan1394 (11/13/2015)
is there any another advanteges for this separation ?
If you just intend to split system objects from user objects and nothing else, then no. If you're using it as...
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
November 14, 2015 at 1:36 am
keithy_sunny (11/13/2015)
However, with the help of DBCC Page command, I find the 'cardfa' table is actually stored in heap
What, from DBCC Page, led you to conclude 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
November 14, 2015 at 1:31 am
pollokoff (11/13/2015)
Must be something with the data that is making it use a clustered index scan when I modify it to use IS NULL.
This, perhaps?
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
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
November 13, 2015 at 1:38 pm
No idea. You need to sit down and figure out why
The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Market'.
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
November 13, 2015 at 1:37 pm
I don't think the problem is the waits...
The merge process could not connect to the Publisher 'ServerName\PSWWW08:DatabaseName_Central'.
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at...
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
November 13, 2015 at 10:48 am
It's not really that simple.
Most of the time, speed comes down to how many rows the query is processing, whether the query can use indexes properly and whether there are...
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
November 13, 2015 at 10:43 am
I didn't ask if you had permissions. Your permissions are completely irrelevant.
I asked whether the account that SQL runs under has permission to that folder
When can you restart the SQL...
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
November 13, 2015 at 6:21 am
Can you remote onto the server and double-check that this path exists and is accessible, and that the account that SQL runs under has full control of that folder?
E:\BM_Replication\Data\
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
November 13, 2015 at 5:00 am
Try taking the DB offline and bringing it back online, see if that fixes things. When SQL tried to open that DB, the E drive was not accessible to 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
November 13, 2015 at 4:41 am
The operating system returned error 21(The device is not ready.) to SQL Server
The E drive, which is where the data file is, is not present or is not online. Speak...
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
November 13, 2015 at 4:05 am
Is this question specific to PerformancePoint Services in SharePoint?
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
November 13, 2015 at 3:53 am
INSERT INTO TableName (A, B)
SELECT B, A FROM TableName
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
November 13, 2015 at 2:17 am
You can look in the default trace, it does track schema changes. However it'll only contain recent history. How recent depends on how active the server it. Could be hours,...
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
November 12, 2015 at 8:55 am
Let me guess, you use the SSMS GUI table designer to make the change?
The table designer creates a new table with the new schema, moves the data across and drops...
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
November 12, 2015 at 7:48 am
What's wrong with the answers you got the last few times you've asked this?
http://www.sqlservercentral.com/Forums/Topic1716720-3411-1.aspx (link to an ebook, suggestions on whitepapers and a stairway article)
http://www.sqlservercentral.com/Forums/Topic1726600-3411-1.aspx (list of DMVs and perfmon...
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
November 12, 2015 at 7:11 am
Viewing 15 posts - 4,291 through 4,305 (of 49,552 total)