GilaMonster (8/22/2014)

---

There's the problem.

Take that filter out, the event will then show up and you...

You should absolutely see a command like:

SELECT * FROM HumanResources.vEmployee AS ve

within a server side trace if you're capturing SQL:BatchStarting. The only reason you wouldn't see that command is because...

If you're doing log shipping, by definition you're backing up the transaction logs. That's how you can move them to another location.

Full backups and log backups, after the very first log backup, are not in any way connected. You're safe to take those backups. Now, if you start introducing differential backups,...

Yep, go to your backups. That's the safest road to recovery here.

And I was thinking the opposite, that the T-SQL would be under the user account while the GUI would be otherwise.

It sounds like a security problem. The GUI works just fine in 2012 (not that I use it or advocate for it). Access denied is a very specific error suggesting...

Sounds like it might be fixed, but if not, no, you shouldn't need to update statistics. When you create an index for the first time, and same thing goes for...

I would suggest looking at the wait statistics by querying sys.dm_os_wait_stats before and after you run your query in order to understand why things are running slowly. I'd also look...

I'm pretty sure most of the projects are backwards compatible within Visual Studio, but only across two-three versions. Database projects where that way within SSDT. Not sure about SSIS, etc.

Paresh Motiwala (8/20/2014)

---

Hi SSCommitted,

I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.

Citing this as one of...

MJ-1115929 (8/20/2014)

---

Hello Grant,

Thanks for shedding some light and highly appreciate the help provided, and nice to meet you , I have read your book on performance tuning and I...

I'm with Jack, I'd suggest getting in direct touch with Microsoft. A crash of the instance is not something simply changing a setting or tuning a query is going to...

er.mayankshukla (8/20/2014)

---

I have tested it.

The page compression on Table reduces the size of table as well as size of Clustered Index without any change in size to NonClustered Index.

Now My...

MJ-1115929 (8/20/2014)

---

Dear Experts,

We have a new project that requires some modeling ,design changes and performance tuning , as of now I am Administration side which I have only basic idea...