Viewing 15 posts - 16,861 through 16,875 (of 49,552 total)
If they are in the primary filegroup, new data will be automatically written to them. SQL will not however re-balance existing data. Read up on proportional fill for how the...
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
August 29, 2012 at 12:41 pm
Never heard of such a trace flag. If one did exist that turned off deferred name resolution, it would spectacularly break procedures that create and use temp tables.
sys.dm_sql_referenced_entities
sys.dm_sql_referencing_entities
These should be...
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
August 29, 2012 at 12:38 pm
No. If it's returning correct now it's fine.
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
August 29, 2012 at 12:13 pm
Hash joins use a work table that's in tempDB. Both hashes and sorts can spill to tempDB as well.
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
August 29, 2012 at 10:21 am
nroberson (8/29/2012)
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
August 29, 2012 at 9:17 am
Depends on how many rows get deleted. If SQL escalates the locks because of the number needed, it will escalate to table unless you enable partition-level escalation (careful if you...
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
August 29, 2012 at 6:18 am
Nope, that's just a login failure, not related at all.
We need all the errors that suggested to you that the file was corrupt. Honestly though, at this point just restore...
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
August 29, 2012 at 6:16 am
Yes, it likely will show nothing now. You need to query at a time that the log is growing or that it's not getting reused.
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
August 29, 2012 at 2:41 am
IN and NOT IN are usually very efficient, sometimes more so that joins. If the number column is nullable that could cause worse performance than expected.
Can you post the 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
August 29, 2012 at 2:22 am
Large transactions would be the first guess. Maybe replication that's not working well.
Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/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
August 29, 2012 at 2:19 am
In the batch where you do the insert you need to set identity insert on (as Clare explained) and you need to list the columns that the insert affects. Both...
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
August 29, 2012 at 12:57 am
Taking a couple steps back...
Missing indexes is there to give you a place to start with creating indexes that may be missing. It is absolutely not something that you want...
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
August 29, 2012 at 12:54 am
As long as the SQL Browser service is running on the server, there should be no issues connecting to a named instance. The client contacts the SQL Browser service, asks...
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
August 28, 2012 at 6:05 pm
Sergiy (8/28/2012)
GilaMonster (8/28/2012)
Well I wrote that portion of that chapter, so I guess what's in there would be my explanation.
So, it should be really easy for you to post 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
August 28, 2012 at 5:56 pm
My complete guess would be that the SQL browser service isn't running or he's got a firewall blocking the higher ports.
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
August 28, 2012 at 5:14 pm
Viewing 15 posts - 16,861 through 16,875 (of 49,552 total)