Notes from the Field Archives - Page 13 of 20 - SQL Authority with Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

[Notes from Pinal]: Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that developers do not know their data, they are often confused with the same and not sure how to answer that. My…

SQL SERVER – Tuning Queries is Sometimes Waste of Time – Notes from the Field #049

October 9, 2014

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 49th episode of Notes from the Field series. Every day I get few emails where I am asked how to tune queries so the entire server run faster. I always end up writing long answer this question. The reason is simple – query tuning…

SQL SERVER – Building Technical Reference Library – Notes from the Field #048

October 2, 2014

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 48th episode of Notes from the Field series. How do you build a technical reference library? In other word, when you need help how do you create your own reference so you do not have to go out to look for further help. There…

SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047

September 25, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

[Notes from Pinal]: There are few things which confuse us when we encounter first time, however, there are few concepts which confuses us even though we face them multiple times. One of the such subjects is database taking a long time to create. Think about it, if you see a…

SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046

September 18, 2014

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using the SSIS Term Extraction for Data Exploration. Linchpin People are database coaches and wellness experts for a data driven world. In…

Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045

September 11, 2014