How to Use the Validation Application Block, Part 1(www.aaronstannard.com)

submitted by Aaronontheweb(1140) 2 years ago

Introduces the Microsoft Enterprise Library Validation Application Block and some of the basic validators, such as regular expression, string length, range, and so forth. read more...

add a comment |category: C# |Views: 13

tags: C# another

SQL SERVER – Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries on SQL Server Box. read more...

add a comment |category: Database |Views: 484

tags: SQLAuthority SQLServer SQL Database pinaldave another

Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Mystery Resolved - One Query to Find Most Expensive Database Query - DMV read more...

add a comment |category: Database |Views: 12

tags: SQLAuthority SQLServer SQL Database pinaldave another

Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

A Story of Disabled Index read more...

add a comment |category: Database |Views: 8

tags: SQLAuthority SQLServer SQL Database pinaldave another

Get Latest SQL Query for Sessions(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

This is number one request from any developer regarding how to see what was the latest query for that session. read more...

add a comment |category: Database |Views: 275

tags: SQLAuthority pinaldave SQLServer Database SQL another

What is AdventureWorks? - The known and the Unknown Story(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The known and the Unknown Story read more...

add a comment |category: Database |Views: 49

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – GUID vs INT – Your Opinion(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Take your side. State your case. Learn the reality. read more...

1 comment |category: Database |Views: 773

tags: SQLAuthority int pinaldave GUID Database another

Create Primary Key with Specific Name when Creating Table(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

Does your PK has big long not readable name? Well this is quick post to save the day! read more...

add a comment |category: Database |Views: 273

tags: SQLAuthority pinaldave SQLServer Database SQL another

Configure Management Data Collection - A Quick Tip for Every Developer(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about how to get more details about these three most important components using the Management Data Collection. Management Data Collection generates the reports for the three said components by default. Configuring Data Collection is a very easy task and can be done very quickly. read more...

add a comment |category: Database |Views: 182

tags: SQLAuthority pinaldave SQLServer Database SQL another

virtual database - A Unique Tool for Testers, DBA, Developers(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB in size, and, to restore it on our production server, it usually takes around 16 to 22 minutes, depending on the load server that is usually present. This range in time varies from one server to another as per the configuration of the computer. Some other issues we used to have are the following: 1. When we try to restore a large 40-GB database, we needed at least that much space on our production server. 2. Once in a while, we even had to make changes in the restored database, and use the said changed and restored database for our purpose, making it more time-consuming. read more...

1 comment |category: Database |Views: 330

tags: SQLAuthority pinaldave SQLServer Database SQL another

Snapshot Databases - A Wonderful Gift to Testers(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

If you do not know how Snapshot database work, here is a quick note on the subject. However, please refer to the official description on Book-on-Line for accuracy. Snapshot database is a read-only database created from an original database called the “source database”. read more...

add a comment |category: Database |Views: 314

tags: SQLAuthority pinaldave SQLServer Database SQL another

World Shapefile Download and Upload to Database – Spatial Database(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

This is very unique post and explains how to create Map of the world using Spatial Data read more...

add a comment |category: Database |Views: 340

tags: SpatialData spatial pinaldave SQLAuthority Database another

SQL SERVER – Interview Questions & Answers Needs Your Help(blog.sqlauthority.com)

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

Here, I need your help. Please your comments, suggestions, expectation or potential interview Question (along with answer) here. Your input will be very valuable. As time goes by we all learn and get better. There were few things missing at that time when those interview questions and answers were prepared, now is the time to complete the gap and make this interview questions more useful. read more...

2 comments |category: Database |Views: 307

tags: SQLAuthority pinaldave SQLServer Database SQL another

Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DA(blog.sqlauthority.com)

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

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE March 17, 2010 by pinaldave | Edit Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT. read more...

add a comment |category: Database |Views: 118

tags: SQLAuthority pinaldave SQLServer Database SQL another

Force Index Scan on Table – Use No Index to Retrieve the Data – Query(blog.sqlauthority.com)

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

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan? read more...

add a comment |category: Database |Views: 122

tags: SQLAuthority pinaldave SQLServer Database SQL another

MAXDOP Settings to Limit Query to Run on Specific CPU(blog.sqlauthority.com)

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

This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single batch. I have now one question for all readers. Do you use this query hint? If you do use it, then what is the purpose of the same. Please leave a comment here. read more...

add a comment |category: Database |Views: 53

tags: SQLAuthority pinaldave SQLServer Database SQL another