What is Data Mining – A Simple Introductory Note(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 8 months ago

According to MacLennan et al. (2009), data mining is defined as “the process of analyzing data to find hidden patterns using automatic methodologies.” Consider the following simple example that explains this concept. By analyzing the data on the items purchased from a supermarket or a chain of such stores, information on the products that are sold most can be obtained and accordingly supply of that particular products are increased and vice versa. Data mining, in short, is an analytical activity that studies the hidden patterns in a huge pile of data after appropriately classifying and sorting it. read more...

4 comments |category: Database |Views: 268

tags: SQLAuthority pinaldave SQLServer Database SQL another

Mirrored Backup and Restore and Split File Backup(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 8 months ago

This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore. 1. Conventional Backup and Restore 2. Spilt File Backup and Restore 3. Mirror File Backup 4. Understanding FORMAT Clause 5. Miscellaneous details about Backup and Restore read more...

add a comment |category: Database |Views: 90

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL Server Express – A Complete Reference Guide(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 8 months ago

SQL Server Express is one of the most valuable products of Microsoft. Very often, I face many questions with regard to SQL Server Express. Today, we will be covering some of the most commonly asked questions. Let me give you quick list of the online help resources. Even though I took some time to build this reference list, I am sure that all of you will appreciate this and will share with others, which is worth the effort! read more...

add a comment |category: Database |Views: 31

tags: SQLAuthority pinaldave SQLServer Database SQL another

A Delayed Analysis(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 8 months ago

What is your opinion? read more...

add a comment |category: Database |Views: 4

tags: MySQL SQLAuthority pinaldave Database SQL another

Measure CPU Pressure(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

Let us understand the simple meaning of CPU pressure. CPU pressure is a state wherein the CPU is fully occupied with currently assigned tasks and there are more tasks in the queue that have not yet started. read more...

add a comment |category: Database |Views: 257

tags: SQLAuthority pinaldave Database SQL another

Get Query Plan Along with Query Text and Execution Count(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following handy script, which I use when I need to know the details regarding how many times any query has ran on my server along with its execution plan. You can add an additional WHERE condition if you want to learn about any specific object. read more...

add a comment |category: Database |Views: 140

tags: SQLAuthority pinaldave Database SQL another

Reason for SQL Server Agent Starting Before SQL Server Engine Service(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why the SQL Server Agent starts before SQL Server Engine does? He made the very valid point that as the SQL Server Engine is the core service, it should start first, and there is little point to running the SQL Server Agent without it. Off the top of my head, I can offer the following quick reasons for this sequence: What are you thoughts on this subject? read more...

1 comment |category: Database |Views: 95

tags: SQLAuthority pinaldave Database SQLServer another

SQL SERVER – Introduction to SQL Server 2008 Profiler(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how queries are resolved internally and what scripts are running to accomplish any T-SQL command. The major functions this tool can perform have been listed below: * Creating trace * Watching trace * Storing trace * Replaying trace read more...

add a comment |category: Database |Views: 228

tags: SQLAuthority pinaldave SQLServer Database SQL another

Introduction to Cloud Computing(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

Simplest Way to Learn what is Cloud Computing read more...

add a comment |category: Database |Views: 670

tags: http//vietzing.com pinaldave Database SQLServer SQLAuthority another

Copy Database With Data – Generate T-SQL For Inserting Data Table(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

How to generate script for data from database as well as table. SQL Server 2008 has simplified everything. This is one feature we all have been waiting for long time. Must learn this trick and save it for future use. read more...

add a comment |category: Database |Views: 426

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – List All Missing Identity Values of Table in Database(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 9 months ago

Very interesting conversation going on on need of this kind of query. What is your opinion? read more...

1 comment |category: Database |Views: 240

tags: SQLAuthority pinaldave SQLServer Database SQL another

Maximizing View of SQL Server Management Studio – Full Screen(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 10 months ago

I had a great, unforgettable time at Teched India 2009 in Hyderabad. I had delivered a successful session on SQL Server Management Studio Best Practices, which created a lot of interest in community. I was truly amazed at the tremendous response I got. I received countless different questions on this subject as soon as the event was over. One of the most frequently asked questions was about my demo on how to increase real estate of SSMS (SQL Server Management Studio). I had explained the following two different methods: read more...

add a comment |category: Database |Views: 378

tags: SQLAuthority pinaldave Database SQLServer another

SQL SERVER – Get Last Running Query Based on SPID(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 10 months ago

We often need to find the last running query or based on SPID need to know which query was executed. SPID is returns sessions ID of the current user process. The acronym SPID comes from the name of its earlier version, Server Process ID. read more...

add a comment |category: Database |Views: 105

tags: SQLAuthority pinaldave SQLServer Database SQL another

SELECT 1 vs SELECT * – An Interesting Observation(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 10 months ago

I have been using SELECT 1 instead of SELECT * when checking existence of rows. I would like to see what my readers have opinion about this. Please have your opinion and make your comment here. read more...

add a comment |category: Database |Views: 816

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Backup Timeline and Understanding of Database Restore Pro(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 10 months ago

In general, databases backup in full recovery mode are taken in three different kinds of database files. 1. Full Database Backup 2. Differential Database Backup 3. Log Backup What really perplexes most people is differential database backup. read more...

add a comment |category: Database |Views: 181

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Languages for BI – MDX, DMX, XMLA(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 10 months ago

Let us go over the languages of BI very quickly. Again, these are just definitions and there is much more to learn. Moreover, to master each language it may take years. read more...

add a comment |category: Database |Views: 231

tags: SQLAuthority pinaldave SQLServer Database SQL another