The data for those is stored in a table, but I suspect you want the image which is only rendered inside SSMS. Take a screenshot and pste it into Word....

Get the SSMS Tools Pack. With it you can right click a table in SSMS Object Explorer and generate the series of INSERT statements required to take your data with...

Get the SSMS Tools Pack. With it you can right click a table in SSMS Object Explorer and generate the series of INSERT statements required to take your data with...

In RAM, by SQLOS.

The buffer pool contains various...

Pages of data stored in memory. Governed by 'max server memory' setting.

Two names for the same thing. Describes bon-buffer-pool memory, i.e. amount is not governed by 'max server memory'...

I suspect your definition of 'group by' might be different than mine. Using the sample data in your first post how would the resultset look if it did a "Group...

The topic is huge and is not conveniently summarized in few words. Most answers can also depend on your understanding of the terms, what does "D/R" mean to you? Recovering...

Grant Fritchey (1/25/2013)

---

Since you're on SQL Server 2012, I would advise avoiding trace events. Instead focus on extended events. They're more light weight and much more programmable. There's no book...

sford-721104 (1/25/2013)

---

We have a couple dozen SSIS packages created in Visual Studio 2005. They run against numerous SQL2005 instances. We are essentially a mainframe shop; therefore...

You can ignore them. SQL Express does not include SQL Server Agent and those tables are only relevant in support of Agent Jobs.

When I try your code as-is and execute the proc I am not seeing any locks opened against TableB which is what I would expect since no FK columns are...

Probably the same reason that a parameterized query cannot always make use of a filtered index. When SQL Server generates a plan that accepts a DATETIME in the WHERE-clause it...

David Ziffer (1/24/2013)

---

OK I answered my own question by just doing it, so I'll post my solution as a public service, since the answer to this problem does not seem...

When you say you "changed it" if you just changed the extension from xls or xlsx to csv then you didn;t change much of anything except the file name. The...

MDS is just a tool within SQL Server that helps implement the concept of Master Data Management. Read up on MDM and you'll have a better understanding of what MDS...