Viewing 15 posts - 9,751 through 9,765 (of 49,552 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.
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
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...
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
March 10, 2014 at 9:56 am
Jack Corbett (3/10/2014)
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
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...
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
March 10, 2014 at 9:20 am
Jack Corbett (3/10/2014)
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
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...
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
March 10, 2014 at 8:37 am
This may answer some of your questions: http://www.sqlservercentral.com/articles/Administration/64582/
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
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...
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
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...
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
March 10, 2014 at 8:28 am
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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
March 10, 2014 at 7:12 am
Ok, that is weird.
Will have to hunt for a memory breakdown script to see what's happening.
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
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?
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
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.
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
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?
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
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.
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
March 9, 2014 at 9:40 am
Viewing 15 posts - 9,751 through 9,765 (of 49,552 total)