Learning SQL Server - Efficient Query Writing Strategy - Gift Book(blog.sqlauthority.com)

submitted by pinaldave(9662) 9 months, 23 days ago

Some people may push back on this next technique or misunderstand until getting to the very end. The goal is to have fewer errors as you write complex queries more quickly by making sure the easy stuff works first. read more...

2 comments |category: Database |Views: 80

tags: Database another

Find Nth Record Quickest Way in SQL Server(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months ago

A Very simple tutorial to find Nth Record. A Quick Tutorial. read more...

add a comment |category: Database |Views: 7

tags: Database another

Database Worst Practices – New Town and New Job and New Disasters(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months, 15 days ago

Instead of writing best practices, I am going to write about few of the worst practices which I have quite often seen in the real world. Some of them are really bad that I often wonder how those who still use them were able to continue on the job so far. Let us go over few of the worst practices I have observed in the industry. read more...

1 comment |category: Database |Views: 211

tags: SQLAuthority SQLServer SQL Database pinaldave another

Two Simple Puzzles - Tease Your Brain - Win Knowledge and Gift(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months, 27 days ago

Today I have two simple T-SQL Puzzle. You can answer them and win USD 25 Gift card. The gift card will be sent in email to winner. You will get choice of Gift Card brand based on your preference and country location. read more...

add a comment |category: Database |Views: 88

tags: SQLAuthority SQLServer SQL Database pinaldave another

SQL Puzzles and Interesting Solutions(blog.sqlauthority.com)

submitted by pinaldave(9662) 10 months, 29 days ago

List of all the interesting puzzles and interesting solutions on my blog. read more...

add a comment |category: Database |Views: 152

tags: Database SQLServer SQLAuthority SQL another

Solution – Generating Zero Without using Any Numbers in T-SQL(blog.sqlauthority.com)

submitted by pinaldave(9662) 11 months, 6 days ago

Generate Zero without using any numbers. An Interesting Puzzle and its solution. read more...

add a comment |category: Database |Views: 149

tags: SQLAuthority SQLServer SQL Database pinaldave another

SELECT * gives error when executed alone but SELECT COUNT(*) does not.(blog.sqlauthority.com)

submitted by pinaldave(9662) 11 months, 26 days ago

Try running SELECT * it will throw an error. Try running SELECT COUNT(*) it will not throw an error. Why? Read, Learn and Participate! read more...

add a comment |category: Database |Views: 101

tags: SQLAuthority SQLServer SQL Database pinaldave another

Copy Database from Instance to Another Instance – Copy Paste in SQL Se(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year ago

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with necessary security permissions. You can automate this process as well control error logging. Following are the steps to copy database from one instance to another instance. read more...

add a comment |category: Database |Views: 43

tags: SQLAuthority SQLServer SQL Database pinaldave another

Pluralsight On-Demand FREE for SQL Server Course(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 1 month ago

Learning is always difficult. After learning how to apply your knowledge, learning in real life is even more difficult. Technology is moving faster than the speed of light and new technologies are always emerging – this is now the reality of the new technology world. Between all of this, I personally have very little time to learn new technology. I do not like eBooks (this statement warrants a whole new blog posts – some other time), I prefer regular books. It is becoming more and more difficult to carry around the books and read them with passion. It happened to me once that by the time I finished the book, there was a new version of the product out in the market. read more...

add a comment |category: Database |Views: 77

tags: SQLAuthority SQLServer SQL Database pinaldave another

Query to Recent Query on Server with Execution Plan Function(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 1 month ago

A quick script to get recently ran query. read more...

add a comment |category: Database |Views: 210

tags: SQLAuthority SQLServer SQL Database pinaldave another

A Hidden Performance Bottleneck - Discover and Resolve(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 2 months ago

I have been working a lot on Wait Stats and Wait Types recently. Last Year, I requested blog readers to send me their respective server’s wait stats. I recorded the wait stats and my recommendations and did further research. At some point at time, there were more than 10 different round trips of the recommendations and suggestions. Finally, after six month of working my hands on performance tuning, I have collected some real world wisdom because of this. Now I plan to share my findings with all of you over here. read more...

add a comment |category: Database |Views: 531

tags: SQLAuthority SQLServer SQL Database pinaldave another

What is a Technology Evangelist?(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 3 months ago

Technology evangelists are individuals who, professionally or in their spare time, spread the news about the latest new products. Sounds like a salesperson, right? No they are absolutely different. Salespeople also keep up to date with a large number of people, and like to convince others to buy their product – and some will go to any lengths to sell! An evangelist, on the other hand, is brutally honest about the product, even if sometimes it means not making a sale. An evangelist is out there to tell the TRUTH. A salesperson needs to make sales. read more...

add a comment |category: Community |Views: 161

tags: SQLAuthority SQLServer SQL Community pinaldave another

If you are Shrinking your Database - This one is for you!(www.dzone.com)

submitted by pinaldave(9662) 1 year, 4 months ago

Shrinking database is one of the very very bad operation of SQL Server. Pinal Dave proves this with example. read more...

add a comment |category: Database |Views: 376

tags: SQLAuthority SQLServer SQL Database pinaldave another

Creating Missing Index and Improve SQL Server Performance(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 4 months ago

A Quick Script which you can right away run and improve SQL Server Performance. read more...

add a comment |category: Database |Views: 516

tags: SQLAuthority SQLServer SQL Database pinaldave another

SQL SERVER – Copy Statistics from One Server to Another Server(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 4 months ago

A very efficient way of copying database statistics from one server to another server without moving data. read more...

add a comment |category: Database |Views: 46

tags: SQLAuthority SQLServer SQL Database pinaldave another

Plan Cache and Data Cache in Memory(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 4 months ago

I get following question almost all the time when I go for consultations or training. I often end up providing the scripts to my clients and attendees. Instead of writing new blog post, today in this single blog post, I am going to cover both the script and going to link to original blog posts where I have mentioned about this blog post. read more...

add a comment |category: Database |Views: 272

tags: Database another