The memory dump is simply the internal binary representation of the row - the raw data as it is stored on the page. In the DBCC PAGE output in the...

MERGE can do that. I'd build you a statement but I'm a little lost on what you're asking.

Corresponding intTrialID by what? Do you mean delete all TableA.intTrialID = 1 rows...

That will be...

While I'm all for having new speakers the Summit isn't the place for real newbies. That's what all the Chapters (real & virtual), SQLSaturday's, SQLRally's, and various online sessions...

Did anybody look at the pictures before responding?

Looks like you're rebuilding an index, or performing other index-modification work. You'll get lots of page latching on metadata pages (mostly the GAM)...

Since you're already passing in a string list of values, and adding them to a dynamic (string) command, why bother splitting them?

DECLARE @sql as varchar(5000) = '

SELECT E.LastName...

PolyServe has reached end-of-life. It beat our experiences with Windows 2003 clustering (such failovers not working or taking too long), but Windows 2008 clustering is an entirely different animal, and...

We have many PolyServe Matrix clusters of up to four physical nodes, each having up to eight SQL Server 2005 Enterprise x64 instances with databases up to 20TB each.

We're phasing...

You can get that info with sys.dm_db_session_space_usage and, at a more granular level, sys.dm_db_task_space_usage.

Pages are 8kB each, so multiply the alloc_page_count and dealloc_page_count values by 8 to get the number...

I generally use info from sys.dm_exec_connections to get that info:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ServerName,

@@SERVERNAME AS FullInstanceName, @@SERVICENAME AS InstanceName,

...

select count(*) as mycount

from partno_table

...is the same this as summing the individual counts.

If you leave the parenthesis off, the NOLOCK becomes a table alias, not a hint.

-- NOLOCK is not a hint here, it's an alias, and has no effect on the...

If you are using a query tool that can connect to pultiple instances, such as SQL 2008's SSMS or RedGate's MultiScript (there are several others), you can issue the following...

There is a create_date column in sys.objects, and there...

Do you have some sort of weekly deployments or script refreshes? If you drop and re-create a procedure, any explicit permissions granted for that procedure get dropped with the...