- Hubs »
- tagged sql server
1-10 of 163 Hubssort by Hot Best Latest
78ASP.NET Cache - How To Use SQL Notification Services With LINQ
Introduction Many ASP.NET applications or web sites are driven by SQL Server databases such as in scenarios such as content management or data driven clients. In a standard ASP.NET application, every request to a web page that has a data store...
1 comment
93How-To Develop CrossTab Queries in T-SQL(Transact-SQL) with Dynamic Columns
This articles provides examples on how to use the pivot function in t-sql, dynamic sql and xml to create dynamic (programmatic) columns in a cross tab or pivot query similar to olap.
4 comments
69How to remove unnecessary hexadecimal folders
Recently I installed Microsoft Sql Server and and after the process there were lots of hexadecimal folders created on some of my drives. The strange thing was this wasn't even the folder that installed Microsoft Sql. After doing some search on...
0 comments
88How to remove duplicate rows (records) from a table in a SQL
Before, I dive into examples I just wanted to ask everyone who is reading this article, how many times did you run a while loop or a cursor? Perhaps you worked on the procedure that inserted records into the table multiple times and the table had no...
0 comments
60SQL Database Hosting Is A Must-Have
When first time you read the word ‘SQL’ what comes in your mind? Probably, you think about code as like HTML. However, it is essential for websites and it is powerful coding behind moves of almost every websites and online businesses. Without...
0 comments
69Learn SQL Server How To Create Views
Example Tables I know that there is plenty of people on net searching helpful topics on database, html, web designing and lot more. Everything is available on web but all is scattered and I would like to...
1 comment
69SQL Server Instance Does Not Start After Restoring Model System Database
Microsoft SQL Server holds a set of the system database that are required for options of Microsoft SQL Server instance. You should backup the system database after each critical update, to prevent...
1 comment
71DBCC DBREINDEX Fails to Rebuild Microsoft SQL Server Database Indexes
Microsoft SQL Server uses indexes to effectively manage the database and improve its performance. It helps database manager to easily locate the specified table and extract it. However, in some situations...
2 comments
67Explanation of SQL Join: Obtaining data from multiple tables using Join
Explanation of SQL Join: Obtaining data from multiple tables using Join. Learn what exactly database join is. Know the syntax of joinging with easy detail explanation. And just remember the types of joining...
0 comments
83How-To Synchronize Data Between Excel and SQL Server | Linked Server
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
2 comments
