DotNetShoutout

SQL 2008

2
Shouts

Shout it

SQL-Articles » SPARSE Column

published 505 days, 23 hours, 14 minutes ago posted by

sqlarticles 506 days, 3 hours, 24 minutes ago

It’s been a long this feature has been released however I just got an opportunity to check it out. This feature is released in SQL Server 2008 version. Sparse columns are normal columns which will store NULL values in a optimized storage which means no storage space is taken when you store NULL values to that column. Happy !! there is some overhead for storing non NULL values to this columns, it will take some more space for non NULL values. (more)

category: Data | clicked: 8 | comment | | source: sql-articles.com

tags: SQL 2008, Development, sparse, database design, sqlarticles

2
Shouts

Shout it

SQL-Articles » Creating a Data Tier Application (DAC) Package

posted by

sqlarticles 612 days, 1 hour, 19 minutes ago

In previously article I’ve covered what is DAC package and how it helps during deployment. In this article I’m going we are going to see how can we create a new data tier application (DAC) package for deployment. All SQL Server related objects can be included in this package for deployment, this includes both database and server level objects. (more)

category: Data | clicked: 1 | 1 comment | | source: sql-articles.com

| flag as spam

tags: DAC, data tier application, DBA, SQL 2008, sqlarticles

2
Shouts

Shout it

Select Find Nth Highest Salary Record In Sql Server

posted by

amitjain 615 days, 10 hours, 11 minutes ago

This is most frequentky asked question how to select or get nth highest record or nth row/record from any column of sql table. for example select get or fetch 2nd (second highest) or nth highest salary of employee or 10th highest record from the table. There are various ways to achieve this result, i've mentioned few here. (more)

category: Data | clicked: 2 | comment | | source: csharpdotnetfreak.blogspot.com

| flag as spam

tags: SQL 2008, Database, ASP.NET

3
Shouts

Shout it

Display Facebook Online Users in Aspnet | DevelopersCode

published 649 days, 21 hours, 50 minutes ago posted by

taanu51 650 days, 8 hours, 43 minutes ago

Hi friends, In this article i would like to explain a simple trick to integrate chating popup window in Aspnet for Facebook lovers First Open the visual studio 2008 Next,select a Aspnet Website and change the name as FacebookChating.aspx Next,Click on the source page of FacebookChating.aspx write the following code in the Head sectionand write the following code in the body sectionThats it..friends.....Subscribe to Get this Post as E Book Other Recommended Posts: Aspnet , Facebook (more)

category: Web Dev | clicked: 23 | comment | | source: www.developerscode.com

tags: ASP .NET 4.0, sql 2005, Facebook, ASP.Net 2.0, ASP .NET AJAX, SQL 2008, C#, c sharp, ASP.NET 2.0 tutorial, ASP .NET 4, C# .NET, ASP.NET

3
Shouts

Shout it

Simple steps to understand Delegates in C# | DevelopersCode

published 649 days, 21 hours, 50 minutes ago posted by

taanu51 650 days, 8 hours, 45 minutes ago

Hi friends, in this article I would like share some important and simple steps about Delegates in C#Steps: 1) Delegates are similar to C++ Function Pointers2) Delegates holds the address of one or Address of many functions 3) Delegate Encapsulates (hides) some information like Class names and method names4) Delegates divided in to 2 types àSingle cast Delegate àMulticast Delegate Single cast Delegate: Single cast holds the address of one function Multicast Delegates: à Multicast cast delegates ho... (more)

category: Web Dev | clicked: 20 | comment | | source: www.developerscode.com

tags: ASP .NET 4.0, sql 2005, ASP.Net 2.0, ASP .NET AJAX, SQL 2008, C#, c sharp, ASP.NET 2.0 tutorial, ASP .NET 4, C# .NET, ASP.NET

3
Shouts

Shout it

Difference between Data Reader and Dataset | DevelopersCode

published 649 days, 21 hours, 50 minutes ago posted by

taanu51 650 days, 8 hours, 46 minutes ago

Hi friends, in this article I would like share some important differences between Data Reader and Dataset Data set: --> Dataset is a class, which is the part of System. Data Namespace --> Dataset supports connectionless architecture. That is, active connection is not required while working with datasets --> Dataset cannot communicate directly with database Hence data adapter is required to carry the data in between dataset and database --> Data Adapter is used to carry the data but ... (more)

category: Web Dev | clicked: 14 | comment | | source: www.developerscode.com

tags: ASP .NET 4.0, sql 2005, ASP.Net 2.0, ASP .NET AJAX, SQL 2008, C#, c sharp, ASP.NET 2.0 tutorial, ASP .NET 4, C# .NET, ASP.NET

3
Shouts

Shout it

Develop your own TextBox with a new enumerated property called as Input Type | DevelopersCode

published 649 days, 21 hours, 50 minutes ago posted by

taanu51 650 days, 8 hours, 47 minutes ago

Hi Friends,In this tutorial i wolud like to explian very interesting topic about creating your own Textbox.Here we are creating two types of text boxes .one Textbox for accepting only digits and another textbox accepting only alphabets(Upper case and lower case) Step 1)First open the visual studio 2008 Step 2)Next open the windows forms control library project and change the name as UserDefinedTextBox Step 3)next open the code view Step 4)change the class declaration as follows public partial clas... (more)

category: Web Dev | clicked: 12 | comment | | source: www.developerscode.com

tags: ASP .NET 4.0, sql 2005, ASP.Net 2.0, ASP .NET AJAX, SQL 2008, C#, c sharp, ASP.NET 2.0 tutorial, ASP .NET 4, C# .NET, ASP.NET

4
Shouts

Shout it

SQL Server Developer Tools, Codename

published 675 days, 10 hours, 14 minutes ago posted by

http://quachnguyen.myopenid.com/ 679 days, 9 hours, 51 minutes ago

...provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the enhanced Server Explorer in VS to easily create or edit database objects and data, or execute queries. Developers will also appreciate the familiar VS tools we bring to database development, specifically; code navigation, IntelliSense, language support that parallels what is available... (more)

category: Architecture | clicked: 7 | comment | | source: code2code.info

tags: SQL 2008

3
Shouts

Shout it

Running SQL Server JOBS with different user accounts in SQL 2008 | TechBubbles

posted by

kalyanms1 679 days, 20 hours, 47 minutes ago

This post discusses about configuring different user account to JOB running in SQL Server 2008. By default SQL JOBs runs under service account that you have configured while installing the SQL Server. You can follow the below steps to change the user account that running under JOB 1. Open SQL Server Management Studio and expand the SQL Server Agent node and Select the JOB that you want to change the running account. Double click the selected JOB then you will get the below dialogue Select... (more)

category: Architecture | clicked: 13 | 1 comment | | source: www.techbubbles.com

| flag as spam

tags: SQL 2008

3
Shouts

Shout it

Install Northwind or pubs database on sql server 2008

published 778 days, 23 hours, 5 minutes ago posted by

amitjain 781 days, 5 hours, 53 minutes ago

n this post i am going to describe how to install northwind or pubs sample database on sql server 2008. Follow steps mentioned below (more)

category: Data | clicked: 1 | comment | | source: csharpdotnetfreak.blogspot.com

tags: SQL Server, pubs, SQL 2008, Northwind

4
Shouts

Shout it

How-to: Quick & Dirty SQL Express scheduled backup

published 824 days, 20 hours, 49 minutes ago posted by

https://www.google.com/profiles/dougrathbone 827 days, 16 hours, 56 minutes ago

SQL Express is pretty awesome as a light weight database server, and when Microsoft released it using the same database engine as the full version they did the world a huge favour. I have seen SQL Express in use on a lot of Virtual Private Servers & development boxes, but in most cases users don’t backup their databases regularly because of the missing scheduled jobs functionality that doesn’t ship in the Express version of Microsoft SQL Server. Like most limitations there is an easy way around this. (more)

category: Data | clicked: 0 | comment | | source: www.diaryofaninja.com

tags: sql 2005, SQL 2008, backup

2
Shouts

Shout it

Check whether an expression is numeric type in sql server - Dot Net logiX

posted by

DotNetLogix 944 days, 9 hours, 45 minutes ago

Check whether an expression is numeric type in sql server - Dot Net logiX (more)

category: Data | clicked: 1 | comment | | source: www.dotnetlogix.com

| flag as spam

tags: sql 2005, SQL 2008, SQL

2
Shouts

Shout it

How to cleare login history of user from sql server

published 944 days, 22 hours ago posted by

DotNetLogix 945 days, 10 hours, 36 minutes ago

How to cleare login history of user from sql server (more)

category: Data | clicked: 0 | comment | | source: www.dotnetlogix.com

tags: sql 2005, SQL 2008

5
Shouts

Shout it

ssms tools pack

published 997 days, 3 hours, 52 minutes ago posted by

http://quachnguyen.myopenid.com/ 997 days, 12 hours, 20 minutes ago

SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2 and their respective Express versions. It contains a few upgrades to the SSMS IDE that I thought were missing. The current features include: • SQL Snippets • Window Connection Coloring • Query Execution History and Current Window History • Format SQL • Search Table, View or Database Data • Run one script on multiple databases • Copy execution plan bitmaps to clipboard or file • Search R... (more)

category: Data | clicked: 0 | comment | | source: code2code.info

tags: SQL 2008, SQL

5
Shouts

Shout it

Use RegEx in SQL with CLR Procs

published 1080 days, 7 hours, 10 minutes ago posted by

http://vistadb.myopenid.com/ 1081 days, 17 hours, 35 minutes ago

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use.SQL CLR can do that! Yes, you can use the .Net regex library using a SQL CLR method registered as a SqlFunction. This example uses VistaDB 4, but the same code will work with SQL Server 2005 / 2008, by changing the using namespaces. I will demonstrate the same code i... (more)

category: Data | clicked: 0 | comment | | source: infinitecodex.com

tags: Regular Expression, SQL 2008, VistaDB, Clr procedures

2
Shouts

Shout it

Microsoft SQL Server 2008 Certification Paths

posted by

tsql 1113 days, 10 hours, 29 minutes ago

Microsoft SQL Server 2008 Certification Paths Microsoft SQL Server database administrators, sql developers, Business Intelligence (BI) professionals who are working with MS SQL Server 2008 can find SQL Server 2008 Certification Paths here (more)

category: Data | clicked: 1 | comment | | source: www.kodyaz.com

| flag as spam

tags: certification, SQL 2008, SqlServer 2008

4
Shouts

Shout it

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard

published 1136 days, 7 hours, 48 minutes ago posted by

eralper 1137 days, 8 hours, 27 minutes ago

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard MS SQL Server 2008 has new Generate Scripts option which enables sql programmers to script data in SQL Server database tables. SQL developers can script data from sql tables into a script file, to the clipboard or script data on a new sql query window. Script data can be used to export and/or import table data from one database to another database. The Script Data option creates INSERT statements foreach row ... (more)

category: Data | clicked: 0 | comment | | source: www.kodyaz.com

tags: SQL 2008, SQL, script data

4
Shouts

Shout it

SQL Backup Compression Default Option in MS SQL Server 2008 sp_configure Command

posted by

eralper 1175 days, 9 hours, 5 minutes ago

SQL Backup Compression Default Option in MS SQL Server 2008 sp_configure Command SQL backup compression is a must tool for many Microsoft SQL Server administrators if you experience disk space problems. (more)

category: Data | clicked: 1 | comment | | source: www.kodyaz.com

| flag as spam

tags: SQL Server, SQL 2008, sql backup, SQL Server 2008, data compression, backup compression

2
Shouts

Shout it

DTS To SSIS Migration: Unable To Cast COM Object Issue

posted by

MarlonRibunal 1210 days, 18 hours, 15 minutes ago

DTS To SSIS Migration: Unable To Cast COM Object Issue2010 January 27tags: COM object, DTS 2000 Runtime, dts to ssis, package migration, unable to cast COM objectby MarlonRibunal I need to migrate the exact package from SQL Server 2000 DTS to SQL Server 2008 SSIS. This particular package is OK to migrate using the “Migrate DTS 2000 Package” Wizard since I don’t have those complicated tasks that won’t simply migrate.The Issue: So I right-click the wizard but when I run it I am getting a “Unable to cast ... (more)

category: Data | clicked: 1 | comment | | source: dbalink.wordpress.com

| flag as spam

tags: SQL 2008, etl, SSIS

2
Shouts

Shout it

SQL-Articles - DotNet 3.5 on Windows 7 to Install SQL Server 2008

posted by

sqlarticles 1217 days, 16 hours, 22 minutes ago

This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks I’m seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5 is required. Windows installer 4.5 is inst... (more)

category: Data | clicked: 3 | comment | | source: www.sql-articles.com

| flag as spam

tags: Windows 7, SQL 2008, sql installation, .NET 3.5

Welcome!

SQL 2008

SQL-Articles » SPARSE Column

SQL-Articles » Creating a Data Tier Application (DAC) Package

Select Find Nth Highest Salary Record In Sql Server

Display Facebook Online Users in Aspnet | DevelopersCode

Simple steps to understand Delegates in C# | DevelopersCode

Difference between Data Reader and Dataset | DevelopersCode

Develop your own TextBox with a new enumerated property called as Input Type | DevelopersCode

SQL Server Developer Tools, Codename

Running SQL Server JOBS with different user accounts in SQL 2008 | TechBubbles

Install Northwind or pubs database on sql server 2008

How-to: Quick & Dirty SQL Express scheduled backup

Check whether an expression is numeric type in sql server - Dot Net logiX

How to cleare login history of user from sql server

ssms tools pack

Use RegEx in SQL with CLR Procs

Microsoft SQL Server 2008 Certification Paths

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard

SQL Backup Compression Default Option in MS SQL Server 2008 sp_configure Command

DTS To SSIS Migration: Unable To Cast COM Object Issue

SQL-Articles - DotNet 3.5 on Windows 7 to Install SQL Server 2008

Open ID Login

Standard Login

Forgot Password?

Sign up