DotNetShoutout - Stories tagged with SQLAuthority
12
Shouts

Many to Many Relationship Made Simpler

published 648 days, 8 hours, 59 minutes ago posted by pinaldavepinaldave 652 days, 20 hours, 26 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Monday, August 08, 2011 9:53:27 AM GMT
We need a new process to map this complex relationship. Sometimes tables exist for the sole purpose of allowing indirect relationships between tables. What do you call tables the handle relationships for other tables? Common terms for these type of tables are mapping tables, bridge tables, or junction tables. Learn about Many to many relationship and Win Free Book (more)
category: Data | clicked: 62 | 2 comments | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
11
Shouts

Learning SQL Server - Efficient Query Writing Strategy - Gift Book

published 648 days, 8 hours, 59 minutes ago posted by pinaldavepinaldave 656 days, 12 hours, 33 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Thursday, August 04, 2011 5:45:47 PM GMT
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. (more)
category: Data | clicked: 56 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
10
Shouts

Find Nth Record Quickest Way in SQL Server

published 660 days, 10 hours, 27 minutes ago posted by pinaldavepinaldave 664 days, 10 hours, 21 minutes ago
Sunday, July 31, 2011 7:52:05 PM GMT Wednesday, July 27, 2011 7:58:14 PM GMT
A Very simple tutorial to find Nth Record (more)
category: Data | clicked: 47 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
12
Shouts

SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters « Journey to SQLAuthority

published 676 days, 19 hours, 14 minutes ago posted by pinaldavepinaldave 679 days, 17 hours, 7 minutes ago
Friday, July 15, 2011 11:05:20 AM GMT Tuesday, July 12, 2011 1:11:59 PM GMT
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. (more)
category: Data | clicked: 118 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
9
Shouts

Two Simple Puzzles - Tease Your Brain - Win Knowledge and Gift

published 687 days, 22 hours, 5 minutes ago posted by pinaldavepinaldave 692 days, 32 minutes ago
Monday, July 04, 2011 8:14:28 AM GMT Thursday, June 30, 2011 5:47:03 AM GMT
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. (more)
category: Data | clicked: 24 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
11
Shouts

SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com « Journey to SQLAuthority

published 690 days, 9 hours, 14 minutes ago posted by pinaldavepinaldave 693 days, 21 hours, 54 minutes ago
Friday, July 01, 2011 9:04:59 PM GMT Tuesday, June 28, 2011 8:24:37 AM GMT
This month has been very interesting month for SQLAuthority.com we had multiple and various puzzles which everybody participated and lots of interesting conversation which we have shared. Let us start in latest puzzles and continue going down. There are few answers also posted on facebook as well. SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator This puzzle involves NULL and throws an error. The challenge is to resolve the error. There are m... (more)
category: Data | clicked: 124 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, Database, pinaldave, SQLAuthority
8
Shouts

SQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL « Journey to SQLAuthority

published 700 days, 8 hours, 36 minutes ago posted by pinaldavepinaldave 700 days, 20 hours, 36 minutes ago
Tuesday, June 21, 2011 9:43:33 PM GMT Tuesday, June 21, 2011 9:42:45 AM GMT
SQL Server MVP and my friend My friend Madhivanan has asked very interesting question on his blog regarding How to Generate Zero without using Any Numbers in T-SQL. He has demonstrated various methods how one can generate Zero. When I posted note regarding how one he has generated Zero without using number in my blog post for Free Online Training, blog readers have come up with few very interesting answers. I really found them very interesting and here I am listing them with due credit. Special mention ... (more)
category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
13
Shouts

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*) « Journey to SQLAuthority

published 718 days, 13 hours, 8 minutes ago posted by pinaldavepinaldave 720 days, 21 hours, 31 minutes ago
Friday, June 03, 2011 5:11:01 PM GMT Wednesday, June 01, 2011 8:47:38 AM GMT
Try running SELECT * it will throw an error. Try running SELECT COUNT(*) it will not throw an error. Why? Read, Learn and Participate! (more)
category: Data | clicked: 116 | 1 comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
9
Shouts

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server « Journey to SQLAuthority

published 724 days, 21 hours, 2 minutes ago posted by pinaldavepinaldave 725 days, 23 hours, 59 minutes ago
Saturday, May 28, 2011 9:16:40 AM GMT Friday, May 27, 2011 6:20:29 AM GMT
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. Specify Source Server Spec... (more)
category: Data | clicked: 39 | 1 comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
10
Shouts

FREE for SQL Server Course

published 756 days, 8 hours, 16 minutes ago posted by pinaldavepinaldave 757 days, 1 hour, 26 minutes ago
Tuesday, April 26, 2011 10:03:13 PM GMT Tuesday, April 26, 2011 4:53:27 AM GMT
The Moral of Story You can watch the most popular SQL Server – TSQL course on Pluralsight On-Demand for FREE for the next 48 hours. It starts NOW! The Story 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... (more)
category: Data | clicked: 1 | 2 comments | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
11
Shouts

SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL « Journey to SQLAuthority

published 767 days, 22 hours, 33 minutes ago posted by pinaldavepinaldave 769 days, 21 hours ago
Friday, April 15, 2011 7:46:27 AM GMT Wednesday, April 13, 2011 9:18:37 AM GMT
This blog post is written in response to the T-SQL Tuesday hosted by Matt Velic. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a interesting choice by Matt. I tried to explain in simpler words regarding APPLY but it is not that easy to explain. Instead Here is the quick theory from BOL: The APPLY operator allows you to invoke a table-valued function for each row returned b... (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQLServer, Database, pinaldave, SQLAuthority
12
Shouts

A Hidden Performance Bottleneck - Discover and Resolve

published 792 days, 9 hours, 12 minutes ago posted by pinaldavepinaldave 792 days, 20 hours, 38 minutes ago
Monday, March 21, 2011 9:07:32 PM GMT Monday, March 21, 2011 9:41:30 AM GMT
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 o... (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
16
Shouts

What is a Technology Evangelist?

published 840 days, 12 hours, 51 minutes ago posted by pinaldavepinaldave 844 days, 11 hours, 50 minutes ago
Tuesday, February 01, 2011 5:27:42 PM GMT Friday, January 28, 2011 6:28:36 PM GMT
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 tel... (more)
category: Architecture | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
9
Shouts

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance « Journey to SQL Authority with Pinal Dave

published 853 days, 11 hours, 24 minutes ago posted by pinaldavepinaldave 853 days, 22 hours, 23 minutes ago
Wednesday, January 19, 2011 6:54:49 PM GMT Wednesday, January 19, 2011 7:56:21 AM GMT
Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.SQL SERVER – SHRINKDATABASE For Every Database in the SQL ServerSQL SERVER – What the Business Says Is Not What the Business Wants I received many comments on Why Database Shrinking is bad. Today we will go over a very interesting example that I have created for the same. Here are the quick steps of the example.Create a test databaseCreate two tables and populate with dataCheck the si... (more)
category: Data | clicked: 1 | 1 comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
11
Shouts

Creating Missing Index and Improve SQL Server Performance

published 859 days, 12 hours, 21 minutes ago posted by pinaldavepinaldave 860 days, 3 hours, 52 minutes ago
Thursday, January 13, 2011 5:58:01 PM GMT Thursday, January 13, 2011 2:27:26 AM GMT
A Quick Script which you can right away run and improve SQL Server Performance. (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
9
Shouts

SQL SERVER – Copy Statistics from One Server to Another Server « Journey to SQL Authority with Pinal Dave

published 865 days, 4 hours, 36 minutes ago posted by pinaldavepinaldave 867 days, 2 hours, 48 minutes ago
Saturday, January 08, 2011 1:43:30 AM GMT Thursday, January 06, 2011 3:30:49 AM GMT
A very efficient way of copying database statistics from one server to another server without moving data. (more)
category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
9
Shouts

SQL SERVER – Server Side Paging in SQL Server 2011 – A Better Alternative

published 886 days, 7 hours, 20 minutes ago posted by pinaldavepinaldave 887 days, 23 hours, 27 minutes ago
Friday, December 17, 2010 10:58:35 PM GMT Thursday, December 16, 2010 6:51:45 AM GMT
Ranking has improvement considerably from SQL Server 2000 to SQL Server 2005/2008 to SQL Server 2011. (more)
category: Data | clicked: 6 | comment | | source: blog.sqlauthority.com
tags: SQLServer, pinaldave, SQLAuthority
11
Shouts

Are you Database Developer or Database Administrator?

published 914 days, 3 hours, 51 minutes ago posted by pinaldavepinaldave 916 days, 18 hours, 39 minutes ago
Saturday, November 20, 2010 2:28:02 AM GMT Wednesday, November 17, 2010 11:39:42 AM GMT
Your opinion matters! (more)
category: Data | clicked: 1 | 1 comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
12
Shouts

Known Unknown of System Stored Procedure of sys.sp_tables

published 946 days, 15 hours, 43 minutes ago posted by pinaldavepinaldave 947 days, 13 hours, 30 minutes ago
Monday, October 18, 2010 2:36:01 PM GMT Sunday, October 17, 2010 4:49:33 PM GMT
http://blog.sqlauthority.com/2010/10/17/sql-server-system-stored-procedure-sys-sp_tables/ (more)
category: Data | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
10
Shouts

SQL SERVER – Encrypted Stored Procedure and Activity Monitor

published 952 days, 15 hours, 51 minutes ago posted by pinaldavepinaldave 953 days, 3 hours, 17 minutes ago
Tuesday, October 12, 2010 2:27:34 PM GMT Tuesday, October 12, 2010 3:02:00 AM GMT
If you are using Encrypted Stored Procedure you not see them in Activity Monitor (more)
category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
Previous 1 2 3 4 Next