|
| Avoiding Global temporary table problems between databasesRead more.. |
| Views: 1076
| Bookmarked: 0
times | By: ayyanarj |
On:
2/16/2010 3:01:22 AM |
Article |
|
|
| In this article,i will show how to String Concatenation and Scope Resolution Operator in SQL Server 2008.Read more.. |
| Views: 765
| Bookmarked: 0
times | By: Dhananjay Kumar |
On:
3/27/2011 7:14:56 AM |
Article |
|
|
| Index will help to improve data retrieving process but must be careful with indexesRead more.. |
| Views: 463
| Bookmarked: 0
times | By: dotnetfish |
On:
10/27/2010 7:25:20 AM |
Article |
|
|
| In this article, I would list out Advantages and Disadvantages using GUID over Integer as primary key in Sql server. Because when you are creating table, you have to decide a correct data type for the primary key for better database performance.Read more.. |
| Views: 858
| Bookmarked: 0
times | By: jalpesh |
On:
12/5/2010 8:35:14 PM |
Article |
|
|
| This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases.Read more.. |
| Views: 751
| Bookmarked: 0
times | By: ninethsense |
On:
5/23/2010 6:06:06 AM |
Article |
|
|
| How to get table,database size in Sql ServerRead more.. |
| Views: 1168
| Bookmarked: 0
times | By: RRaveen |
On:
5/18/2010 10:16:42 AM |
Article |
|
|
| Different Options for Importing Data into SQL ServerRead more.. |
| Views: 934
| Bookmarked: 0
times | By: Mohammad Shahanshah Ansari |
On:
6/18/2010 11:29:49 AM |
Article |
|
|
| In sql server there are 2 built-in stored procedures for drop the already existing backup device and create the new device in the user defined path.Read more.. |
| Views: 548
| Bookmarked: 0
times | By: youngmurukan |
On:
5/8/2010 11:50:20 PM |
Article |
|
|
| The SQL Server provides very useful feature which is Begin, Commit, Rollback Transaction.Read more.. |
| Views: 1478
| Bookmarked: 1
times | By: youngmurukan |
On:
5/31/2010 11:31:40 PM |
Article |
|
|
| A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Read more.. |
| Views: 610
| Bookmarked: 0
times | By: dotnetfish |
On:
12/22/2010 10:38:20 PM |
Article |
|
|
| Sql server joins are used to combine result data from two or more tables. Often we need to display data from two tables. Where sql server joins are very useful.Read more.. |
| Views: 428
| Bookmarked: 0
times | By: jalpesh |
On:
6/9/2010 10:25:57 AM |
Article |
|
|
| Recently I have been working on a article for codegain for that I just tried to add a database file on my solution with visual studio and I have received following error.Read more.. |
| Views: 931
| Bookmarked: 0
times | By: jalpesh |
On:
8/2/2010 11:00:37 AM |
Article |
|
|
| In this article, i will explore about new features in SQL server 2010 management studio.Read more.. |
| Views: 619
| Bookmarked: 0
times | By: jalpesh |
On:
5/9/2011 8:54:30 AM |
Article |
|
|
| SQL Server 2008 FILESTREAM FeatureRead more.. |
| Views: 1003
| Bookmarked: 0
times | By: amalhashim |
On:
2/15/2010 11:30:10 PM |
Article |
|
|
| SQL Server 2008 Creating FILESTREAM Enabled DatabaseRead more.. |
| Views: 713
| Bookmarked: 0
times | By: amalhashim |
On:
2/15/2010 11:30:11 PM |
Article |
|
|
| This writing is like an encyclopedia for the SQL statements and stored procedures used to enumerate, attach, and detach databases on a SQL Server instance. It lists the statements and stored procedures that you can use and discusses them in simple examples.Read more.. |
| Views: 804
| Bookmarked: 0
times | By: Geming Leader |
On:
9/2/2010 3:14:50 PM |
Article |
|
|
| How to call SSIS package from the stored procedureRead more.. |
| Views: 2550
| Bookmarked: 0
times | By: justchiragpatel |
On:
2/16/2010 12:44:03 AM |
Article |
|
|
| Export data from SQl server to excel file and send mail with attachmentRead more.. |
| Views: 3851
| Bookmarked: 0
times | By: Kirti.M.Darji |
On:
2/15/2010 10:14:16 PM |
Article |
|
|
| Execute DTS Package using ScriptRead more.. |
| Views: 1077
| Bookmarked: 0
times | By: Kirti.M.Darji |
On:
2/15/2010 10:14:16 PM |
Article |
|
|
| Database Trigger : SQL Server 2005 - Part 1Read more.. |
| Views: 1904
| Bookmarked: 0
times | By: Jana |
On:
2/15/2010 11:56:44 PM |
Article |
|
|
| SQL Sever Interview QuestionsRead more.. |
| Views: 2310
| Bookmarked: 1
times | By: questpond |
On:
2/16/2010 12:02:28 AM |
Article |
|
|
| Get list of View,Tables and Stored Procedures in Sql ServerRead more.. |
| Views: 2069
| Bookmarked: 0
times | By: RRaveen |
On:
2/15/2010 10:59:47 PM |
Article |
|
|
| Sql Server 2005 Features – Part 1Read more.. |
| Views: 86
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| In this article, you will learn few no of sql queries and functions to use in sql server.Read more.. |
| Views: 473
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| Views in SQL Server 2005Read more.. |
| Views: 458
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| In recent past there are many projects around ETL just only Data transfer from the legacy databases. But because of security concerns some of the data needs to encrypted and pushed across the Server. Here I just want to give a brief detail. And just to help the beginners.Read more.. |
| Views: 802
| Bookmarked: 0
times | By: Chinna Srihari |
On:
11/7/2010 6:55:35 AM |
Article |
|
|
| Trying to setup MSSQL 2005 Developer version in my new machine OS Windows XP Professional SP3, when come to installation point, error message below appearRead more.. |
| Views: 930
| Bookmarked: 0
times | By: dotnetfish |
On:
9/6/2010 10:13:35 AM |
Article |
|
|
| In this article, I am going to explain with steps to,install sql server 2011 CTP release in your windows 7 or server PC.The Sql server 2011 CTP release code name is "Denali".Read more.. |
| Views: 712
| Bookmarked: 0
times | By: jalpesh |
On:
4/22/2011 10:04:13 AM |
Article |
|
|
| This lesson discusses all the details of SQL Server logins. It begins by discussing how to create SQL Server logins. After that, it focuses on how to change the properties of existing login. Next, it discusses how to delete an existing login. Moreover, we will focus on how to enumerate a list of existing logins and roles. Lastly, we will talk a look on how to manage login permissions in SQL Server. In addition, we will link between SQL Server and .NET Framework and we will teach you many techniqRead more.. |
| Views: 767
| Bookmarked: 0
times | By: Geming Leader |
On:
9/2/2010 11:47:26 AM |
Article |
|
|
| SQL Server 2008 automatically compress data stored in database. SQL server does Lossless data compression.Read more.. |
| Views: 544
| Bookmarked: 0
times | By: Dhananjay Kumar |
On:
1/17/2011 9:36:25 AM |
Article |
|
|
| I planned to post some performance tuning steps ,mostly DB design related.Read more.. |
| Views: 1178
| Bookmarked: 0
times | By: Mohammad Shahanshah Ansari |
On:
6/18/2010 11:01:29 AM |
Article |
|
|
| In this article, I will explain how to recover data in sql server. Sometimes by chance database is corrupted or suspected, on this time you have to recover database to use. On this article clearly explained step by steps to recover it.Read more.. |
| Views: 404
| Bookmarked: 0
times | By: youngmurukan |
On:
1/11/2011 7:37:29 PM |
Article |
|
|
| We can create view using stored procedure dynamically.Read more.. |
| Views: 587
| Bookmarked: 0
times | By: dotnetfish |
On:
10/9/2010 1:12:30 AM |
Article |
|
|
| In this article i will discuss How to Delete Parent and Child Records in Database using Stored Procedure and C#.This is very beneficial while deleting multiple records from DataGrid or Gridview.Read more.. |
| Views: 892
| Bookmarked: 0
times | By: Sanjay Verma |
On:
12/10/2010 8:35:59 AM |
Article |
|
|
| Stored procedures are stored in SQL Server databases. The simplest implication of stored procedures is to save complicated queries to the database and call them by name, so that users won’t have to enterRead more.. |
| Views: 831
| Bookmarked: 0
times | By: youngmurukan |
On:
7/20/2010 10:01:24 AM |
Article |
|
|
| Performance difference between EXEC and sp_executesqlRead more.. |
| Views: 1519
| Bookmarked: 0
times | By: ayyanarj |
On:
2/16/2010 3:01:22 AM |
Article |
|
|
| Randomly selecting records from the Table - SQL ServerRead more.. |
| Views: 777
| Bookmarked: 0
times | By: ayyanarj |
On:
2/16/2010 3:01:22 AM |
Article |
|
|
| Query for importing datas from XL to SqlServer DBRead more.. |
| Views: 540
| Bookmarked: 0
times | By: vinothnat |
On:
2/15/2010 10:34:37 PM |
Article |
|
|
| Multiple rows in a single row with separator in SqlServerRead more.. |
| Views: 996
| Bookmarked: 0
times | By: vinothnat |
On:
2/15/2010 10:34:37 PM |
Article |
|
|
| Sum of previous rows value in SqlServerRead more.. |
| Views: 1261
| Bookmarked: 0
times | By: vinothnat |
On:
2/15/2010 10:34:37 PM |
Article |
|
|
| Inserting Bulk Data in SQL Server from Text fileRead more.. |
| Views: 1047
| Bookmarked: 0
times | By: vinothnat |
On:
2/15/2010 10:34:38 PM |
Article |
|
|
| Ways to Improve SQL Server Peroformance - Part 1Read more.. |
| Views: 587
| Bookmarked: 0
times | By: justchiragpatel |
On:
2/16/2010 12:44:03 AM |
Article |
|
|
| Ways to Improve SQL Server Performance - Part 2Read more.. |
| Views: 1913
| Bookmarked: 0
times | By: justchiragpatel |
On:
2/16/2010 12:44:03 AM |
Article |
|
|
| Convert function In SQlRead more.. |
| Views: 926
| Bookmarked: 0
times | By: Kirti.M.Darji |
On:
2/15/2010 10:14:12 PM |
Article |
|
|
| Export data from SQL Server to MS AccessRead more.. |
| Views: 2069
| Bookmarked: 0
times | By: muhammadshahidfarooq |
On:
2/16/2010 12:20:17 AM |
Article |
|
|
| How to insert records from te one table to another table in SQLRead more.. |
| Views: 897
| Bookmarked: 0
times | By: RRaveen |
On:
2/15/2010 10:59:47 PM |
Article |
|
|
| how to get how many records entered in day by a user in sql server.Read more.. |
| Views: 689
| Bookmarked: 0
times | By: RRaveen |
On:
2/15/2010 10:59:47 PM |
Article |
|
|
| How to select random records in SQl ServerRead more.. |
| Views: 1121
| Bookmarked: 0
times | By: RRaveen |
On:
2/15/2010 10:59:47 PM |
Article |
|
|
| I have read few questions in forums, about how to select first, last date month and how many days in a month. In my project had used some query to perform these tasks. I will share those with article.Read more.. |
| Views: 991
| Bookmarked: 0
times | By: RRaveen |
On:
12/17/2010 9:55:10 AM |
Article |
|
|
| Common Table Expression(CTE) in Sql server 2005Read more.. |
| Views: 950
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| Differences between the stored procedures and triggersRead more.. |
| Views: 515
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| Differences between procedures and functions in Sql ServerRead more.. |
| Views: 1091
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| In this article I have listed few methods to know about the list of database, tables, viewsRead more.. |
| Views: 1084
| Bookmarked: 0
times | By: skumaar_mca |
On:
2/16/2010 3:06:03 AM |
Article |
|
|
| Use of Dense_Rank() function in SQL ServerRead more.. |
| Views: 885
| Bookmarked: 1
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| Use of Rank() function in SQL ServerRead more.. |
| Views: 1155
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| How to use Partition Analytical Function in SQLRead more.. |
| Views: 838
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| Link a Query results with a TableRead more.. |
| Views: 604
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| SQL Server Union queryRead more.. |
| Views: 776
| Bookmarked: 0
times
| By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| Show Row number in query result in MSSQL Server 2005Read more.. |
| Views: 1692
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| SQL Server Union queryRead more.. |
| Views: 149
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| How to search wildcards character in stringRead more.. |
| Views: 966
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| How to get the summary on total by using Group with Rollup in SQL ServerRead more.. |
| Views: 1184
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| How to get the summary on total by using Group with cube in SQL SERVERRead more.. |
| Views: 842
| Bookmarked: 0
times | By: youngmurukan |
On:
2/15/2010 9:42:15 PM |
Article |
|
|
| This article describes how to develop a Microsoft SQL Profiler with .NET.Read more.. |
| Views: 510
| Bookmarked: 0
times | By: ninethsense |
On:
6/6/2010 8:54:23 AM |
Article |
|