|
|
-
|
|
After reading the XQuery Labs many people asked me if I could build such a resource page for articles that explains the usage of FOR XML. Here is a list of short articles I have previously published. I will keep updating this page as and when new articles on FOR XML is published. Happy reading! ......
|
|
-
|
|
Count Down has started for the much awaited Tech-ED Ahmedabad (IT Pro – SQL Server). Just 9 days left for the event. For event details and registration, visit: http://techedahmedabad.eventbrite.com/ Pinal has launched a competition to spread the word in the community about the event. Read his post:......
|
|
-
|
|
For those of you who missed Tech-ED India 2009 last month, there is a reason to rejoice. Tech-ED is coming to Ahmedabad on 20th June 2009. Mark your calendars and be at Hotel Rock Regency, CG Road, Ahmedabad on 20th June 2009 by 1.30 PM. We will have a number of SQL Server sessions: SQL Server Best......
|
|
-
|
|
The Unattended installer can take two additional parameters (optional) to configure FILESTREAM as part of the installation process. /FILESTREAMLEVEL This parameter can be used to specify the FILESTREAM Access Level. This parameter can take one of the following values to configure FILESTREAM with ......
|
|
-
|
|
I am very glad to announce the news that we have finally created a logo for BeyondRelational.com. Here is the new ‘beyondrelational’ logo. TSQL Challenges, a popular channel we run at beyondrelational.com has got a new logo as well. <img style="border......
|
|
-
|
|
SERVERPROPERTY() function can be used to retrieve the Windows Share name configured for FILESTREAM access. Here is an example: SELECT SERVERPROPERTY ('FILESTREAMShareName') AS FileSreamShareName/*FileSreamShareName--------------------KATMAIFS*/
......
|
|
-
|
|
I saw this question recently in one of the forums and wrote a small piece of code to retrieve this. SELECT name, CASE WHEN is_percent_growth = 0 THEN LTRIM(STR(growth * 8.0 / 1024,10,1)) + ' MB, ' ELSE 'By '</sp......
|
|
-
|
|
In XQuery Lab 10 we saw how to insert an attribute to an XML document and in XQuery Lab 11, we say how to insert an element to an XML Document. We have not seen an example that inserts an XML fragment to another XML document. So, let us see how to do this.
SQL Server 2005 does not allow inserting X......
|
|
-
|
|
The XQuery implementation of SQL Server 2005 supported only a limited number of XQuery functions. SQL Server 2008 added support for two more XQuery functions: upper-case() and lower-case() Both these functions are pretty simple to understand and self explanatory. The following example demonstrates ......
|
|
-
|
|
I am not sure how many times you might want to forcefully close all the active connections and drop a database. However, this is a very interesting question. One option to do this is to take the database in SINGLE USER mode and then issue a DROP DATABASE command. USE master;GOALTER DATABASE db......
|
|