DotNetShoutout - Stories tagged with SQL Server 2011

SQL Server 2011

atom rss
2
Shouts
spam Shout it Mute it

SQL-Articles » IIF function – SQL Server Denali
published 570 days, 10 hours, 50 minutes ago posted by sqlarticlessqlarticles 572 days, 17 hours, 54 minutes ago
Sunday, October 30, 2011 8:41:35 PM GMT Friday, October 28, 2011 1:38:27 PM GMT
IIF function is new to SQL Server Denali however if you worked with MS Access then you are familiar with this function. So if you are upgrading a database from Access to SQL Server Denali you don’t need to worry about rewriting the IIF function queries. IIF function will evaluate the expression and it will return one value out of two input values. Read more: http://sql-articles.com/articles/general/iif-function-sql-server-denali/#ixzz1c5Ej6pGn (more)
category: Data | clicked: 9 | comment | | source: sql-articles.com
tags: Development, TSQL, denali, sqlarticles, IIF, SQL Server 2011
3
Shouts
spam Shout it Mute it

SQL-Articles » New DMV’s in SQL Server 2011 aka Denali
posted by sqlarticlessqlarticles 630 days, 17 hours, 41 minutes ago
Wednesday, August 31, 2011 1:51:33 PM GMT
Denali CTP3 is already released and we have new DMV’s accompanied with this version which will be very useful for us. I’m going to cover the DMV that are all generic and not to a specific feature of Denali, I’ll will cover those DMV’s while writing article on that feature. There are around 8 DMV’s which I’m going to discuss it now.Below are the list of DMV’s that I’m talking about Read more: http://sql-articles.com/articles/dba/new-dmvs-in-sql-server-2011-aka-denali/#ixzz1Wc9Tw7DY (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: DBA, denali, Administration, sqlarticles, dmv, SQL Server 2011
2
Shouts
spam Shout it Mute it

Default FileStream filegroup is not available in database 'DatabaseName'
published 663 days, 14 hours, 23 minutes ago posted by eralpereralper 664 days, 20 hours, 52 minutes ago
Friday, July 29, 2011 5:09:28 PM GMT Thursday, July 28, 2011 10:39:44 AM GMT
With SQL Server 2011, a new table type FileTable is introduced for SQL Server developers and administrators. To create FileTable is easy but has some prerequisites. Before completing these prerequisites if t-sql developers try to create FileTable using CREATE TABLE command, the following SQL Engine error might happen Msg 1969, Level 16, State 1, Line 1 Default FILESTREAM filegroup is not available in database 'DatabaseName' (more)
category: Data | clicked: 14 | comment | | source: www.kodyaz.com
tags: SQL Server, denali, SQLServer, FILESTREAM, sql 2011, SQL Server 2011
3
Shouts
spam Shout it Mute it

New T-SQL Functions in SQL Server 2011 for T-SQL Developers
published 675 days, 22 hours, 54 minutes ago posted by eralpereralper 680 days, 11 hours, 16 minutes ago
Sunday, July 17, 2011 8:37:44 AM GMT Tuesday, July 12, 2011 8:16:15 PM GMT
Microsoft SQL Server 2011 introduces new functions for T-SQL developers with SQL Server Denali CTP3 version. These 14 new T-SQL built-in functions are part of T-SQL and programmability enhancements for developers in SQL Server 2011 (more)
category: Data | clicked: 12 | comment | | source: www.kodyaz.com
tags: SQL Server, T-SQL, denali, SQL Server 2011
3
Shouts
spam Shout it Mute it

SQL Analytic Functions new in SQL Server 2011 for T-SQL Developers
published 675 days, 22 hours, 54 minutes ago posted by eralpereralper 680 days, 11 hours, 17 minutes ago
Sunday, July 17, 2011 8:37:44 AM GMT Tuesday, July 12, 2011 8:14:53 PM GMT
Microsoft SQL Server 2011 introduces Analytic Functions for T-SQL developers with SQL Server Denali CTP3 version. Analytic functions have been in Oracle database platform for PL/SQL programmers for a while. Analytic functions in SQL Server is a new enhancement for tsql programmers with SQL Server 2011, aka Denali (more)
category: Data | clicked: 4 | comment | | source: www.kodyaz.com
tags: T-SQL, denali, SQL Server 2011
4
Shouts
spam Shout it Mute it

New T-SQL Features in SQL Server 2011
published 841 days, 14 hours, 4 minutes ago posted by JudoJudo 842 days, 23 hours, 25 minutes ago
Tuesday, February 01, 2011 5:27:42 PM GMT Monday, January 31, 2011 8:07:32 AM GMT
This article introduces four new TSQL commands in SQL SErver 2011 - WithResultSet, Offset, Throw and Sequence. (more)
category: Data | clicked: 0 | comment | | source: www.sql-server-performance.com
tags: sequence, TSQL, throw, Offset, WithResultSer, SQL Server 2011
2
Shouts
spam Shout it Mute it

Adding Startup parameter made easy in Denali «Vidhya Sagar – Blog
published 856 days, 21 hours, 40 minutes ago posted by sqlarticlessqlarticles 859 days, 16 hours, 7 minutes ago
Monday, January 17, 2011 9:51:42 AM GMT Friday, January 14, 2011 3:25:28 PM GMT
You folks might have already know that a new version of SQL Server is on the way to market. Right now beta version of SQL Denali (aka SQL Server 2011) is released. In this version addition of startup parameter is made easy and effort less. In previous version we will be adding it in a text box separating each entry with semi colon(;) .  There is a chance that we might miss that semi colon and it will result in SQL server startup failure. To over come ... (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: denali, startup parameters, sql 2011, SQL Server 2011
3
Shouts
spam Shout it Mute it

How to Script Data in MS SQL Server 2011 using Generate and Publish Scripts Wizard
published 910 days, 10 hours, 32 minutes ago posted by eralpereralper 911 days, 1 hour, 9 minutes ago
Wednesday, November 24, 2010 9:00:16 PM GMT Wednesday, November 24, 2010 6:22:43 AM GMT
SQL Server database administrators and t-sql developers have first introduced with scripting data in sql tables with Microsoft SQL Server 2008 Microsoft SQL Server 2008 has additional Generate Scripts options enable admins and programmers to generate scripts of data in SQL Server tables. The script wizard had some changes after SQL2008, with MS SQL Server 2008 R2 and now with Microsoft SQL Server 2011, Denali CTP 1. (more)
category: Data | clicked: 0 | comment | | source: www.kodyaz.com
tags: SQL Server, data, denali, CTP, script, SQL Server 2011
4
Shouts
spam Shout it Mute it

SQL Paging in SQL Server 2011 using SQL ORDER BY OFFSET and FETCH NEXT
published 909 days, 5 hours, 3 minutes ago posted by eralpereralper 911 days, 1 hour, 11 minutes ago
Friday, November 26, 2010 2:29:08 AM GMT Wednesday, November 24, 2010 6:21:16 AM GMT
One of the major SQL Server 2011 features related with t-sql programming enhancements is the SQL paging using ORDER BY OFFSET n ROWS and FETCH NEXT n ROWS ONLY syntax. In this sql tutorial, while showing one of the new t-sql features in SQL Server 2011 Denali, I will use the sample SQL database AdventureWorks download from CodePlex (more)
category: Data | clicked: 0 | 2 comments | | source: www.kodyaz.com
tags: Paging, SQL, T-SQL, denali, SQL Server 2011
3
Shouts
spam Shout it Mute it

SQL Sequences and Create Sequence of Numbers in SQL Server 2011
published 910 days, 10 hours, 32 minutes ago posted by eralpereralper 911 days, 1 hour, 12 minutes ago
Wednesday, November 24, 2010 9:00:16 PM GMT Wednesday, November 24, 2010 6:19:46 AM GMT
In SQL Server, t-sql developers sometimes require to create sequence of numbers which will be used in more than one sql tables. One of the SQL Server 2011 features and enhancements in t-sql development is Sequence Objects. A SQL Server sequence object generates sequence of numbers just like an identity column in sql tables. But the advantage of sequence numbers is the sequence number object is not limited with single sql table. There is no direct relation between tables, table identity columns and num... (more)
category: Data | clicked: 0 | comment | | source: www.kodyaz.com
tags: sequence, T-SQL, denali, SQL Server 2011
2
Shouts
spam Shout it Mute it

Download SQL Server 2011 Sample Databases including AdventureWorks Database
posted by eralpereralper 924 days, 23 hours, 12 minutes ago
Wednesday, November 10, 2010 8:20:22 AM GMT
Microsoft has released the Microsoft SQL Server 2011 CTP1, the first Community Technology Preview (CTP) of next version of MS SQL Server. The release of Microsoft SQL Server 2011 CTP1, and the the coming closer of the RTM release date SQL Server 2011 sample databases are being more required for SQL Server administrators and T-SQL programmers. In order to apply the enhancements in Microsoft SQL Server 2011, a sample database like AdventureWorks or Northwind is preferred by SQL Server professionals. (more)
category: Data | clicked: 4 | comment | | source: www.kodyaz.com
tags: SQL Server, AdventureWorks, SQL Server 2011