Viewing 15 posts - 4,291 through 4,305 (of 49,571 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...
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?
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/
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'.
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...
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...
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...
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\
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,...
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...
November 13, 2015 at 4:05 am
Is this question specific to PerformancePoint Services in SharePoint?
November 13, 2015 at 3:53 am
INSERT INTO TableName (A, B)
SELECT B, A FROM TableName
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,...
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...
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...
November 12, 2015 at 7:11 am
Viewing 15 posts - 4,291 through 4,305 (of 49,571 total)