(Jen McCown) We got a question recently that basically boiled down to this: Nested views shouldn’t be such a performance suck. Why doesn’t Microsoft make the optimizer deal with nested views better?
Tag: sql server
SSIS – Configure a source flat file with a fixed width from an existing table
(Ron Kirchgessner) SQL Server Integration Services (SSIS) can import data from a fixed width flat text file (i.e. no field delimiters), using the Flat File Source component. When importing this type of file, you must set the field names, field widths, and starting positions ahead of time.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
(Pinal Dave) As a DBA or SQL Developer, the amount of time we work with SQL Server Management can never be measured. As a database person, these hidden gems of SQL Server can never be underestimated.
C-R-U-D The Basics
(Chris Yates) What is CRUD? Well, there are a lot of things I can think of when I use the term CRUD; however within the wonderful world of technology CRUD is an acronym that surprisingly enough, when I polled, didn’t really give a straight answer. That really surprised me; so with that said I will w
Poor-Man’s Disaster Recovery: Use Log Shipping for SQL Server (at Your Own Risk)
(Thanh “OJ” Ngo) This week, we’ll take a closer look at part 2 of our series on application high availability and disaster recovery (HA/DR) for SQL Server: Log shipping for SQL Server implementations.
Identifying large queries using Extended Events
(Andrew Pruski) Following on from my last blog post I now want to run through how to identify large queries using Extended Events.
Query Object Dependencies
(Derik Hammer) SQL Server Management Studio has a decent interface for viewing object dependencies, check out TechNet for those procedures. But, we all know the value of being able to run queries for the information that we need. There are two methods that we’re going to cover for finding object dep
SSRS deploying reports using RS.EXE command line video
(Scott Murray) SSRS 2012 reports can be deployed in various ways including:
Questions about Primary and Foreign Keys You Were Too Shy to Ask
(Robert Sheldon) It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys.
SQL SERVER – Beginning In-Memory OLTP with Sample Example
(Pinal Dave) In-Memory OLTP is a wonderful new feature introduced in SQL Server 2014. My friend Balmukund Lakhani has written amazing series on A-Z of In-Memory on his blog. All serious learner should study it for deep understanding of the same subject.