Viewing 15 posts - 7,816 through 7,830 (of 49,571 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,...
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.
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 ] ] ) [...
September 15, 2014 at 8:33 am
Anyone remember more of Access than I do?
http://www.sqlservercentral.com/Forums/Topic1613613-2799-1.aspx
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...
September 15, 2014 at 7:39 am
The exec_sql_text DMV has dbid and objectid columns. Use those to identify particular procedures.
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
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...
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...
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?
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...
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...
September 15, 2014 at 5:36 am
An MS Access database? Or linked tables to SQL Server?
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,...
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...
September 15, 2014 at 3:15 am
Viewing 15 posts - 7,816 through 7,830 (of 49,571 total)