Viewing 15 posts - 7,816 through 7,830 (of 49,552 total)
The syntax for creating an index on a partition scheme is
CREATE INDEX ...
ON partition_scheme ( column_name )
You have to specify the column name directly and alone in the partition scheme,...
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
September 15, 2014 at 9:41 am
Depends. If you see frequent fragmentation, you can drop it down slightly (not a lot, bit by bit). There's no value which is always correct for all cases.
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
September 15, 2014 at 8:36 am
The partition function is of the form:
CREATE PARTITION FUNCTION partition_function_name ( input_parameter_type )
AS RANGE [ LEFT | RIGHT ]
FOR VALUES ( [ boundary_value [ ,...n ] ] ) [...
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
September 15, 2014 at 8:33 am
Anyone remember more of Access than I do?
http://www.sqlservercentral.com/Forums/Topic1613613-2799-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
September 15, 2014 at 8:18 am
They're database pages, they're in the database file, like all other database pages are.
No, they're not in TempDB. If they were, then you'd have to restore databases from backup after...
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
September 15, 2014 at 7:39 am
The exec_sql_text DMV has dbid and objectid columns. Use those to identify particular procedures.
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
September 15, 2014 at 7:10 am
Not Page Files. Pages. They're pages in the database, like any other page.
Try this: http://www.amazon.com/Microsoft-Server-Internals-Developer-Reference/dp/0735658560
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
September 15, 2014 at 7:09 am
Gazareth (9/15/2014)
GilaMonster (9/14/2014)
Consider using a RAMDisk for Index filegroups.
Putting non-clustered indexes on a...
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
September 15, 2014 at 6:18 am
I gave you a solution. Stop copy-pasting existing data, or write up an access form that gives you the behaviour that you want to see.
It's nothing to do with 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
September 15, 2014 at 6:13 am
Ok, not too bad.
Do you have a clean backup from before the corruption occurred as well as an unbroken chain of log backups up to current time?
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
September 15, 2014 at 5:49 am
It's not deleting it. It's failing to insert it. Duplicate values are not permitted in a unique constraint.
As I just explained, because you're having the insert fail, the identity value...
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
September 15, 2014 at 5:48 am
You're going to have to have a look at the definition of the view and test, on the SQL side, why inserts fail. Maybe one of the fields you're not...
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
September 15, 2014 at 5:36 am
An MS Access database? Or linked tables to SQL Server?
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
September 15, 2014 at 4:06 am
codykonior (9/13/2014)
Is there any rule of thumb for allocating log space for doing reorgs and rebuilds in a worst case scenario?
~1.5*the size of the largest index in the database,...
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
September 15, 2014 at 3:50 am
In that case, I usually take profiler traces (well, server side traces) for a couple of hours of peak usage, pull wait stats, locking stats, perfmon counters and whatever more...
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
September 15, 2014 at 3:15 am
Viewing 15 posts - 7,816 through 7,830 (of 49,552 total)