dhara
Name: dhara
Score: 12,446.92
Last Seen: 424 days, 1 hour, 56 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
9
Shouts

How to use ExportSqlCE to migrate from SQL Server to SQL Compacts

published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1034 days, 21 hours, 58 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Friday, August 20, 2010 9:27:36 AM GMT
Release 2.5 of the SQL Compact schema and data script utility Codeplex project contains a new command line utility, named Export2SqlCe, that allows you to export schema and data from a SQL Server 2005/2008 database in a SQL Compact compatible SQL format. (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server Compact, SQL Server
11
Shouts

VS 2010 Database Project and Page Verify SQL setting

published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1035 days, 2 hours, 4 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Friday, August 20, 2010 5:20:55 AM GMT
When we create a new database using SSMS, by default Page Verify Option for database is set to CHECKSUM, which is a recommended option and it helps detecting corruption. This setting is used to discover and report incomplete I/O transactions caused by disk I/O errors. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, DBA
10
Shouts

SQL Server - Writing IF-ELSE code in TSQL

published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1035 days, 21 hours, 45 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Thursday, August 19, 2010 9:40:36 AM GMT
This article intends to help the beginners to get started with Transact SQL code that uses IF-ELSE logic. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL
7
Shouts

SQL Server Performance Monitoring and Alerts using Quest SpotLight - SQL Server Tools In My Environment

published 1036 days, 16 hours, 53 minutes ago posted by jacobsebastianjacobsebastian 1036 days, 22 hours, 16 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Wednesday, August 18, 2010 9:09:13 AM GMT
Keeping a watch on the SQL Server instances, databases and ensuring their health is one of the fundamental responsibility of a DBA. In this post, Malathi Mahadeven explains how Quest SpotLight is used in her environment for SQL Server monitoring and alerting. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: Performance, SQLServer, Tools, Quest Software
12
Shouts

Hosting a WCF REST Service with WebServiceHost - Debug Mode

published 1034 days, 13 hours, 42 minutes ago posted by dharadhara 1036 days, 2 hours, 20 minutes ago
Friday, August 20, 2010 5:43:13 PM GMT Thursday, August 19, 2010 5:05:13 AM GMT
WebServiceHost factory helps us to host a WCF REST Service in managed application. This class is derived from ServiceHost class and automatically enables webHttpBinding and webHttpBehavior on the service End points (more)
category: Web Dev | clicked: 7 | comment | | source: beyondrelational.com
tags: ASP .NET, dot net
9
Shouts

How to fix SQL Server Row Size Limit issue

published 1036 days, 16 hours, 53 minutes ago posted by dharadhara 1037 days, 22 hours, 34 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Tuesday, August 17, 2010 8:50:54 AM GMT
QL Server throws error of “Cannot create a row of size 8180 which is greater than the allowable maximum row size of 8060” in Insert/Update statements, This means your SQL statement having fields which are LOB data types and exceeds the limit of row size which is 8086 bytes for physical data store in database how ever It does not have issue with Text and Images as they are stored separately. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: DBA, TSQL
12
Shouts

VS2010 Parallel Tasks - Debugging enhancement in VS2010 - Hima's blog

published 1037 days, 15 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1040 days, 35 minutes ago
Tuesday, August 17, 2010 4:21:41 PM GMT Sunday, August 15, 2010 6:50:43 AM GMT
VS2010 has new concept for Parallel Programming that is added as part of .NET Framework 4.0. This makes the ability to work in multi-core processor Environment. Digging through the code and debugging in parallel programming would definitely help. (more)
category: Web Dev | clicked: 0 | 2 comments | | source: beyondrelational.com
tags: VS, Debugging, Visual Studio 2010, paralle programming, Visual Studio
10
Shouts

SQL Server - The power of @@rowcount, and the pit falls, if you do not use them correctly! - Madhivanan's TSQL Blog

published 1036 days, 16 hours, 53 minutes ago posted by dharadhara 1039 days, 1 hour, 25 minutes ago
Wednesday, August 18, 2010 2:32:16 PM GMT Monday, August 16, 2010 6:00:49 AM GMT
It is very easy to embed a serious bug in your TSQL code by incorrectly using the @@rowcount function. This post demonstrates the correct way of using it.... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, ROWCOUNT
9
Shouts

SQL Server NULLIF() function - Understand how it works internally, or you might get unexpected results. - Dave Ballantyne's Blog

posted by dharadhara 1040 days, 21 hours, 5 minutes ago
Saturday, August 14, 2010 10:20:29 AM GMT
While the SQL Server NULLIF() function is very handy in many cases, there are a few things you need to keep in mind while using this function. This posts presents some of those scenarios where you might find unexpected results. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: DBA, TSQL
Previous 1 2 ... 34 35 36 37 38 39 40 41 42 43 Next