Comma Separated Values (CSV) from Table Column(blog.sqlauthority.com)

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

You need it yesterday, bookmark today and use it tomorrow! read more...

1 comment |category: Database |Views: 348

tags: SQLAuthority pinaldave SQLServer Database SQL another

A Common Design Problem – Should the Primary Key Always be a Clustered(blog.sqlauthority.com)

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

The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one would not do the same? read more...

add a comment |category: Database |Views: 53

tags: SQLAuthority pinaldave SQLServer Database SQL another

Interesting Observation – TOP 100 PERCENT and ORDER BY(blog.sqlauthority.com)

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

If you have any similar ideas as the above one, please leave a comment here. read more...

add a comment |category: Database |Views: 55

tags: SQLAuthority pinaldave SQLServer Database SQL another

Understanding Table Hints with Examples(blog.sqlauthority.com)

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

Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how they are helpful. read more...

add a comment |category: Database |Views: 21

tags: SQLAuthority pinaldave SQLServer Database SQL another

Policy Based Management – Create, Evaluate and Fix Policies(blog.sqlauthority.com)

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

This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional administration assistance to DBAs and helps them effortlessly manage various tasks of SQL Server across the enterprise. read more...

add a comment |category: Database |Views: 44

tags: SQLAuthority pinaldave SQLServer Database SQL another

Insert Data From One Table to Another Table(blog.sqlauthority.com)

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

Following three questions are many time asked on this blog. How to insert data from one table to another table efficiently? How to insert data from one table using where condition to anther table? How can I stop using cursor to move data from one table to another table? There are two different ways to implement inserting data from one table to another table. read more...

add a comment |category: Database |Views: 468

tags: SQLAuthority pinaldave Database SQLServer another

Introduction to Business Intelligence – Important Terms & Definitions(blog.sqlauthority.com)

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

What is Business Intelligence Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. .... and many more.... read more...

add a comment |category: Database |Views: 210

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Recently Executed T-SQL Query(blog.sqlauthority.com)

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

About a year ago, I wrote blog post about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER. The Short Answer in is both of them will be deprecated. Please refer to following update query to recently executed T-SQL query on database. read more...

add a comment |category: Database |Views: 74

tags: SQLAuthority pinaldave SQLServer Database SQL another

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

Exploring C# Boxing (dijksterhuis.org)

submitted by martijn(445) 3 years, 2 months ago

Boxing in C# has little to do with Saturday night television and quite a bit more however with that part-time job at the warehouse you had as a student. It is an important concept in C# that is related to how the compiler handles different kinds of variables in memory. Knowing how the compiler handles the various types allows you to avoid unexpected side effects in your code. This article explains what boxing is, how it works and how it can negatively effect your code if you don’t pay attention to it. read more...

2 comments |category: C# |Views: 450

tags: C# another

SQL SERVER - Find All Servers From Local Network - Using sqlcmd(blog.sqlauthority.com)

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

Very simple and very quick. Something when ran on your command prompt will surprise you with result. You may find servers running and active, which you are unaware of. Try it. Bookmark it! This is corrected link. read more...

1 comment |category: Database |Views: 230

tags: SQLAuthority pinaldave SQLServer Database SQL another

10 C# Shorthands that improve productivity(dijksterhuis.org)

submitted by martijn(445) 3 years, 2 months ago

One of the best things about C# is that as the language and libraries expand thought is put into keeping things readable. Below I have listed 10 shorthands that you can use to make your code tighter and less wordy. No doubt you know one or more already — but do you currently use all ten of them ? read more...

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

tags: C# another

SQL Server MSDTC settings(sqlserveradvisor.blogspot.com)

submitted by sqlserveradvisor(385) 3 years, 2 months ago

During installation of a new Windows OS I set the following properties for the MSDTC security settings and transaction timeout. Required when you want to configure and use linked servers read more...

add a comment |category: Database |Views: 41

tags: Database another

How .NET Regular Expressions Really Work(moserware.com)

submitted by moserware(1665) 3 years, 2 months ago

A very deep dive into the source code for how .NET Regular Expressions really work read more...

3 comments |category: Regular Expressions |Views: 609

tags: RegEx another

Interesting Observation of ON Clause on LEFT JOIN(blog.sqlauthority.com)

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

Very simple explanation of : Although the placement of such predicates does not make a difference for INNER joins, they might cause a different result when OUTER joins are involved. This is because the predicates in the ON clause are applied to the table before the join, whereas the WHERE clause is semantically applied to the result of the join. read more...

5 comments |category: Database |Views: 330

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL Server Stored Procedures(blackwasp.co.uk)

submitted by BlackWasp(4212) 3 years, 2 months ago

The twenty-third part of the SQL Server Programming Fundamentals tutorial describes stored procedures. A stored procedure allows you to create a script, or batch, containing multiple commands to be executed, potentially being controlled by parameters. read more...

add a comment |category: Database |Views: 18

tags: Database another