By tag: pinaldave
0
kicks
Database Worst Practices – New Town and New Job and New Disasters
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 h...
0
kicks
Two Simple Puzzles - Tease Your Brain - Win Knowledge and Gift
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.
0
kicks
Solution – Generating Zero Without using Any Numbers in T-SQL
Generate Zero without using any numbers. An Interesting Puzzle and its solution.
0
kicks
SELECT * gives error when executed alone but SELECT COUNT(*) does not.
Try running SELECT * it will throw an error.
Try running SELECT COUNT(*) it will not throw an error.
Why? Read, Learn and Participate!
0
kicks
Copy Database from Instance to Another Instance – Copy Paste in SQL Se
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...
0
kicks
Pluralsight On-Demand FREE for SQL Server Course
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 personall...
0
kicks
Query to Recent Query on Server with Execution Plan Function
A quick script to get recently ran query.
0
kicks
A Hidden Performance Bottleneck - Discover and Resolve
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...
0
kicks
What is a Technology Evangelist?
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 t...
0
kicks
If you are Shrinking your Database - This one is for you!
Shrinking database is one of the very very bad operation of SQL Server.
Pinal Dave proves this with example.
0
kicks
Creating Missing Index and Improve SQL Server Performance
A Quick Script which you can right away run and improve SQL Server Performance.
0
kicks
SQL SERVER – Copy Statistics from One Server to Another Server
A very efficient way of copying database statistics from one server to another server without moving data.
0
kicks
SQL SERVER – Server Side Paging in SQL Server 2011 – A Better Alternat
A Better Alternative of the SQL Server Paging.
0
kicks
Are you Database Developer or Database Administrator?
Your opinion matters!
Are you Database Developer or Database Administrator?
0
kicks
Known Unknown of System Stored Procedure of sys.sp_tables
Do you know even simple query like sys.tables can kill the performance of your system.
There are better thing to use: Read more...