DotNetShoutout - Stories tagged with sql server 2012

sql server 2012

atom rss
2
Shouts
spam Shout it Mute it

SQL-Articles » AWE option no longer available in SQL Server 2012
published 451 days, 17 minutes ago posted by sqlarticlessqlarticles 459 days, 12 hours, 52 minutes ago
Monday, February 27, 2012 9:47:43 AM GMT Saturday, February 18, 2012 9:12:51 PM GMT
AWE (Addressing Windows Extension) is one of the know server configuration to everyone. This parameter allows SQL Server to access large amount of memory in 32 bit machines. However MS decided to depreciate this configuration in SQL Server 2012 (Denali) . Read more: http://sql-articles.com/articles/dba/awe-option-no-longer-available-in-sql-server-2012/#ixzz1mloUk5bQ (more)
category: Data | clicked: 7 | comment | | source: sql-articles.com
tags: DBA, awe, sqlarticles, sql 2012, sql server 2012, x86, 32 bit, memory
5
Shouts
spam Shout it Mute it

SQL Server 2012 Developer Training Kit BOM
published 466 days, 17 hours, 15 minutes ago posted by kinj312kinj312 469 days, 14 hours, 38 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 7:27:15 PM GMT
The SQL Server 2012 Early Adoption Team has put together some great resources to assist developers with skilling up on SQL Server 2012; one of which is the SQL Server 2012 Developer Training Kit BOM wiki. The wiki, which is based on the SQL Server 2012... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL, sql server 2012
7
Shouts
spam Shout it Mute it

SQL Server 2012 – new conversion functions
published 498 days, 13 hours, 39 minutes ago posted by kinj312kinj312 498 days, 22 hours, 54 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Tuesday, January 10, 2012 11:11:07 AM GMT
With SQL Server 2012 comes a new set of conversion functions , that will certainly help doing type casts and conversions in t-sql. These functions are: TRYPARSE TRYCONVERT PARSE TRYPARSE() Syntax from BOL: TRYPARSE ( stringvalue AS datatype [ USING... (more)
category: Data | clicked: 16 | comment | | source: beyondrelational.com
tags: SQL Server, denali, sql server 2012
6
Shouts
spam Shout it Mute it

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) – Part 2
published 513 days, 59 minutes ago posted by dharadhara 516 days, 2 hours, 5 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:00:19 AM GMT
In my last post, SQL Server 2012: Detecting Sort Warnings with Extended Events (sortwarning event) I showed how to use sortwarning event with sql_text action to detect sort warnings in database with statements sent to SQL server instance. We also saw... (more)
category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
8
Shouts
spam Shout it Mute it

SQL server 2012 Startup parameters
published 514 days, 1 hour, 50 minutes ago posted by dharadhara 516 days, 23 hours, 36 minutes ago
Monday, December 26, 2011 8:15:27 AM GMT Friday, December 23, 2011 10:29:12 AM GMT
I’m sure that I’m not the only one with nightmares about the startup parameters in older versions of SQL Server 200x – the design and UI is just bad, it is so easy to forget a semicolon or mess up the syntax – and to end up with SQL Server that is not... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
9
Shouts
spam Shout it Mute it

SQL Server 2012 Developer Training Kit
published 518 days, 10 hours ago posted by kinj312kinj312 519 days, 24 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Wednesday, December 21, 2011 9:41:25 AM GMT
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here ). This update includes eleven new hands-on labs covering Integration Services, the Semantic Model and Power View. Roger Doherty posted a complete... (more)
category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
7
Shouts
spam Shout it Mute it

CONCAT() – SQL Server 2012
published 519 days, 14 hours, 33 minutes ago posted by kinj312kinj312 526 days, 48 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Wednesday, December 14, 2011 9:17:28 AM GMT
With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of the concatenation of two or more strings – if the input is another type than string a conversion will be done implicit. The CONCAT() function takes... (more)
category: Data | clicked: 11 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali, sql server 2012