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

submitted by pinaldave(9662) 10 months, 16 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 pinaldave SQLServer Database SQL another

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

submitted by pinaldave(9662) 10 months, 28 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: 89

tags: SQLAuthority pinaldave SQLServer Database SQL another

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

submitted by pinaldave(9662) 11 months ago

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

add a comment |category: Database |Views: 152

tags: Database SQLAuthority SQLServer SQL another

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

submitted by pinaldave(9662) 11 months, 7 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 pinaldave SQLServer Database SQL another

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

submitted by pinaldave(9662) 11 months, 27 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 pinaldave SQLServer Database SQL 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 pinaldave SQLServer Database SQL 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 pinaldave SQLServer Database SQL 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 pinaldave SQLServer Database SQL 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 pinaldave SQLServer Database SQL another

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

submitted by pinaldave(9662) 1 year, 4 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 pinaldave SQLServer Community SQL 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 pinaldave SQLServer Database SQL 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 pinaldave SQLServer Database SQL 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 pinaldave SQLServer Database SQL another

SQL SERVER – Server Side Paging in SQL Server 2011 – A Better Alternat(blog.sqlauthority.com)

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

A Better Alternative of the SQL Server Paging. read more...

add a comment |category: Database |Views: 405

tags: SQLAuthority pinaldave Database SQLServer another

Are you Database Developer or Database Administrator? (blog.sqlauthority.com)

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

Your opinion matters! Are you Database Developer or Database Administrator? read more...

add a comment |category: Database |Views: 250

tags: SQLAuthority pinaldave SQLServer Database SQL another

Known Unknown of System Stored Procedure of sys.sp_tables(blog.sqlauthority.com)

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

Do you know even simple query like sys.tables can kill the performance of your system. There are better thing to use: Read more... read more...

add a comment |category: Database |Views: 95

tags: SQLAuthority pinaldave SQLServer Database SQL another