Hey There!!

SSMS 12/14 are operating the same way at the lower level.

The last example shows this perfectly. There are that many lines ( albeit they aren't shown ) Think about...

Hey Snargables,

So there are a handful of answers that might be more specific if you give some detail on what errors, or where they are seen.

SSIS - yes you can...

Hey Buck,

Execute As -- So, here is the short description: It will work for the SPID it is created for.

An example: When you open a tab for a new query...

Hi Roust,

Have you taken a look at Reporting Services configuration? Sounds like maybe the server it is "hitting" the db for may be the reporting services server ?

Another possibility to...

Hi Farzad,

When you say a table doesn't have the right collation: do you perhaps mean the columns are showing the wrong collation? Columns will keep the collation after they have...

Hello,

I just spent last week going over this!

You may want to do some research on Microsoft's Future policy for Service Packs. There are some hints out there that they are...

Angelo,

SQL Server Profiler is something part of the whole Standard package. What level of SQL do you have? ( standard/enterprise )

Here is a great run through with lots of information...

Hi arooj,

First Question: http://sqldbasupport.wordpress.com/2009/07/21/sql-server-architecture/

Second Question: The portion of the log file from the MinLSN to the last-written log record is called the active portion of the log.

Third Question:...

Thomas,

I would be remiss if I didn't tell you - SQL SERVER PROFILE.

If you are looking to really dig into understanding what SQL is doing... I would strongly suggest this...

Hey Thomas,

In my experience, there haven't been performance gains found by splitting data pulls as-is. That being said if you can break up the processing of what this "Behemoth sproc"...

Hello,

Well the only thoughts I have there are as follows:

Shared Memory Protocol is going to be default/best practice IF and ONLY IF the application and database is on the same...

Same as the other user - We have 2012 running over a ton of physical machines and virtual machines with no issue. Unless you want to talk about SSAS :)...

Hi Ramana,

Without reading the transaction log and/or log backups (which may be impossible, if msdb is set to the default simple recovery), I am not sure there is a way...

Hey Angelo,

If you ( or anyone ) are running into deadlocks you need to see the deadlock happening to really figure out how to resolve.

The very best way I have...

Sorry for the delay - it didn't send the updates through to my email! I was wondering about this so I logged on- sorry man!

Okay first - ya Wireshark is...