SqlServerKudos - Stories tagged with database

database

atom rss
1
kudos
spam Kudos Remove

Windows IT Pro 2010 Community Choice Awards - Vote for SQLCentric
posted by sasa 10 hours, 7 minutes ago
Thursday, September 09, 2010 5:18:40 PM GMT
Windows IT Pro 2010 Community Choice Awards - Vote for SQLCentric
Windows Magazine network is conducting another series of community choice awards, which is your chance to vote for your favourite product that helped you before and promoting to the community. If you are a DBA then you will know the best results of such community product solutions, I'm not referring about paid third party tools. The tools which are freely available to use. For SQL Server specific you can choose any of the following that appeals to your work: IT Pros: Submit your choices here . Database..... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: community, database, DBA, free tools, performance monitoring, SQL Server, sqlcentric, third party
1
kudos
spam Kudos Remove

XQuery Lab 57 – Getting Started with OPENXML
published 74 days, 14 hours, 30 minutes ago posted by sasa 83 days, 15 hours, 34 minutes ago
Sunday, June 27, 2010 12:56:03 PM GMT Friday, June 18, 2010 11:51:41 AM GMT
XQuery Lab 57 – Getting Started with OPENXML
This post intends to help you get started with OPENXML() function. OPENXML() lets you shred an XML document or fragment into a result set. Though OPENXML() has got no direct relationship with XQuery, I thought of including it in the XQuery Labs series Read More......(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: #XML, #XQUERY, database, DBA, OPENXML, sp_xml_preparedocument, sp_xml_removedocument, SQLServer, TSQL, XML, xquery, xquery labs
1
kudos
spam Kudos Remove

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog
published 76 days, 14 hours, 40 minutes ago posted by jacobsebastianjacobsebastian 84 days, 16 hours, 45 minutes ago
Friday, June 25, 2010 12:46:09 PM GMT Thursday, June 17, 2010 10:40:31 AM GMT
FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog
SQL Server uses GUID values to name the FILESTREAM folders and you might find it really hard to relate a folder to a table or column. This post explains how you can do it. (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
tags: BLOB, DAC, database, DBA, filestream, SQLServer
2
kudos
spam Kudos Remove

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts
published 77 days, 14 hours, 45 minutes ago posted by jacobsebastianjacobsebastian 86 days, 14 hours, 23 minutes ago
Thursday, June 24, 2010 12:41:12 PM GMT Tuesday, June 15, 2010 1:03:29 PM GMT
SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts
In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)
category: Warehousing | clicked: 0 | comment | | source: beyondrelational.com
tags: analysis, Cube, Data Mining, Data Warehousing, database, Dimension, SQLServer, SSAS
1
kudos
spam Kudos Remove

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog
published 78 days, 14 hours, 50 minutes ago posted by jacobsebastianjacobsebastian 87 days, 14 hours, 24 minutes ago
Wednesday, June 23, 2010 12:36:16 PM GMT Monday, June 14, 2010 1:02:28 PM GMT
XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog
This post explains how to write XML DML queries uisng XQuery in TSQL that deals with UNICODE character strings. (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
tags: database, SQLServer, unicode, XML, xml dml, xquery
1
kudos
spam Kudos Remove

T-SQL Enhancements in SQL 2008
published 81 days, 15 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 90 days, 17 hours, 33 minutes ago
Sunday, June 20, 2010 12:21:33 PM GMT Friday, June 11, 2010 9:53:29 AM GMT
T-SQL Enhancements in SQL 2008
Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)
category: Query | clicked: 3 | comment | | source: beyondrelational.com
tags: database, Developer, Programmability, SQL Server, TSQL
1
kudos
spam Kudos Remove

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners
published 83 days, 15 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 92 days, 22 hours, 27 minutes ago
Friday, June 18, 2010 12:11:40 PM GMT Wednesday, June 09, 2010 4:58:56 AM GMT
TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners
This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)
category: Query | clicked: 1 | comment | | source: beyondrelational.com
tags: Challenge, database, Developer, Puzzle, SQL Server, TSQL
1
kudos
spam Kudos Remove

Building Products and Building Materials Information Resource - ASC Info
published 100 days, 16 hours, 31 minutes ago posted by building-productsbuilding-products 108 days, 18 hours ago
Tuesday, June 01, 2010 10:54:41 AM GMT Monday, May 24, 2010 9:25:37 AM GMT
Building Products and Building Materials Information Resource - ASC Info
The ASC Info database contains more than 30,000 companies and 70,000 products, making it one of the largest sources of building product information worldwide. (more)
category: News | clicked: 0 | comment | | source: www.ascinfo.co.uk
tags: aec, architect, architectural, architecture, ASC, building, catalog, companies, company, construction, database, directory, manufacturer, manufacturers, materials, online, ProductCenter, products, supplier, suppliers
1
kudos
spam Kudos Remove

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available
published 104 days, 16 hours, 47 minutes ago posted by sasa 112 days, 16 hours, 6 minutes ago
Friday, May 28, 2010 10:38:48 AM GMT Thursday, May 20, 2010 11:20:29 AM GMT
SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available
Self-Service Business Intelligence is the new solution from SQL Server 2008 R2 that enables the end users to access, analyze and share data across the enterprise in an IT managed environment using Excel 2010 and SharePoint Sever 2010, no need for complex coding techniques. Data Platform Insider blog announces that volume licensing downloads for SQL Server 2008 R2 are available today in all languages, including the public availability of the much anticipated PowerPivot functionality, delivering on...(read... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: business intelligence, database, Excel, powerpivot, powerpoint, self-service, SQL Server, SQL Server 2008 R2, Tools
1
kudos
spam Kudos Remove

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download
published 119 days, 17 hours, 54 minutes ago posted by sasa 128 days, 20 hours, 21 minutes ago
Thursday, May 13, 2010 9:31:46 AM GMT Tuesday, May 04, 2010 7:05:02 AM GMT
SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download
IN contintuation to SQL Server 2008 R2 announcement here is the good news for MSDN & Technet subscribers, see SQL Server 2008 R2 is now available to MSDN and TechNet subscribers go to your relevant subscriptions to download. Don't forget to uninstall the previous & current SQL Server 2008 R2 CTP releases (by taking database backups) and install afresh for further testing. Good luck.... more to come on R2 here!...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: backups, best practice, Blocking, database, Installation, r2, SQL Server
1
kudos
spam Kudos Remove

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
published 193 days, 22 hours, 20 minutes ago posted by pinaldavepinaldave 203 days, 18 hours, 51 minutes ago
Sunday, February 28, 2010 5:06:08 AM GMT Thursday, February 18, 2010 8:35:26 AM GMT
SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: database, pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!
published 233 days, 4 hours, 25 minutes ago posted by sasa 239 days, 8 hours, 5 minutes ago
Tuesday, January 19, 2010 11:01:24 PM GMT Wednesday, January 13, 2010 7:20:44 PM GMT
Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!
Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to upto date service pack on SQL Server 2005 which is SP3 & SQL Server 2008 which is SP1. So here is the reminder for you to ensure to upgrade the 2005 & 2008 instances to upto date service packs, by testing them thoroughly which is a best practice....(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, database, rtm, service pack, sp2, SQL Server, Version, year