Viewing 15 posts - 9,751 through 9,765 (of 49,571 total)
Especially when some of our roads look like this: https://twitter.com/Deirdre91388179/status/442926357560184832/photo/1. I drove down that road a week ago.
March 10, 2014 at 10:06 am
sqlbuddy123 (3/10/2014)
And did you restart the SQL server after you changed the Max Memory to 4 GB ? This is to release excessive memory grabbed by SQL.
Max server memory does...
March 10, 2014 at 9:56 am
Jack Corbett (3/10/2014)
March 10, 2014 at 9:55 am
Jack Corbett (3/10/2014)
No just 90 minutes total, and that's probably actually longer than it'll actual take most days.
That's about what my commute is now, though it's closer to...
March 10, 2014 at 9:20 am
Jack Corbett (3/10/2014)
March 10, 2014 at 8:59 am
Remove the table from replication
Drop all foreign keys referencing this table (may require removing other tables from replication)
Drop the pk
Recreate the PK clustered
Recreate all foreign keys
Add the tables back into...
March 10, 2014 at 8:37 am
This may answer some of your questions: http://www.sqlservercentral.com/articles/Administration/64582/
March 10, 2014 at 8:35 am
kramaswamy (3/10/2014)
Question 1 - Can I simply delete Index 1?
Yes, it's a left-based subset of Index 3 meaning that it's redundant with Index 3
Question 2 - Is there any...
March 10, 2014 at 8:31 am
The technical details on large page allocation: http://blogs.msdn.com/b/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx
The two limitations with large page allocations are that the memory must be contiguous and that the memory allocation is static once allocated...
March 10, 2014 at 8:28 am
Ok, that is weird.
Will have to hunt for a memory breakdown script to see what's happening.
March 10, 2014 at 5:30 am
Min server memory is fine at 0. What's the exact value for max server memory?
Run
exec sp_configure 'show advanced', 1
RECONFIGURE
exec sp_configure 'max server memory'
What's the exact output?
March 10, 2014 at 5:12 am
Ok, so you don't actually have a PK at all. Could be anything. Ask the vendor, they're the only ones who can tell you why the constraint isn't there.
March 10, 2014 at 3:12 am
Still not following.
Are you talking about the primary key constraint? Or some other constraint? What exactly is the problem here?
March 10, 2014 at 2:51 am
What doesn't work?
That's a derived table that Jessie posted, you'd put it in the join clause and join to it like a table.
March 9, 2014 at 9:40 am
Viewing 15 posts - 9,751 through 9,765 (of 49,571 total)