DotNetShoutout

SQLServer

9
Shouts

Shout it

SQL Server App_name() function - find out which application has modified your data - Madhivanan's TSQL Blog

posted by

jacobsebastian 1023 days, 1 hour, 2 minutes ago

This post explains how to use the App_name() function to identify the client application that makes modifications to your data (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

| flag as spam

tags: app_name(), TSQL, SQLServer

9
Shouts

Shout it

Backup of a FILESTREAM database may include garbage files as well - Jacob's Blog

published 1023 days, 1 hour ago posted by

jacobsebastian 1023 days, 10 hours, 2 minutes ago

This post is based on the observation that the backup of a FILESTREAM database includes garbage files as well. The repro example given in this post demonstrates that (more)

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

tags: backup, SQLServer, FILESTREAM

6
Shouts

Shout it

SQL SERVER – Computed Column – PERSISTED and Performance

published 1023 days, 1 hour ago posted by

pinaldave 1023 days, 21 hours, 43 minutes ago

Did you know computed columns are computed at run time? Yes or No? If yes, you know the answer of following question: Is it better with performance or not? If no, go on and read it... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

8
Shouts

Shout it

SQL Server - Count(*) or Count(1) ? - Which is better? - Dave Ballantyne's Blog

published 1024 days, 20 minutes ago posted by

jacobsebastian 1024 days, 9 hours, 28 minutes ago

This post explains the differences between COUNT(*) and COUNT(1) and helps you to decide which one is better (more)

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

tags: TSQL, SQL, Performance, SQLServer, Database

7
Shouts

Shout it

TSQL Challenge 35 - Find the total number of 'Full Attendees' in each 24 HOP Session

posted by

jacobsebastian 1025 days, 41 minutes ago

The recent 24-hours-of-pass or more widely known as #24HOP on twitter and other social media was one of the most exciting SQL Server events that happened recently. For this challenge, we created some (fake) attendance data for this event. Your task is to count the number of attendees who watched the complete presentation of each speaker. (more)

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

| flag as spam

tags: tsql challenges, TSQL, puzzles, SQLServer

8
Shouts

Shout it

Time Zone Awareness For Global Organization

published 1025 days, 53 minutes ago posted by

jacobsebastian 1025 days, 6 hours, 33 minutes ago

This article explains the importance of time zone calculations for global organizations and introduces the time-zone aware data types and functions in SQL Server (more)

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

tags: timezone, SQLServer

6
Shouts

Shout it

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example « Journey to SQL Authority with Pinal Dave

published 1025 days, 53 minutes ago posted by

pinaldave 1025 days, 21 hours, 7 minutes ago

In one of the recent consultancy, I was asked if I can give working example of BINARYCHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows. However, if the row is changed from A to B and once again changed back to A, the BINARYCHECKSUM cannot be used to detect the changes. Let us see quick example of the of same. Following example is modified from the original example taken from BOL. U... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

10
Shouts

Shout it

SQL Server - Difference between TSQL Functions CAST() and CONVERT() - Madhivanan's TSQL Blog

published 1025 days, 53 minutes ago posted by

jacobsebastian 1026 days, 6 hours, 45 minutes ago

This post explains the differences between TSQL functions CAST() and CONVERT(). Though they seem identical, there are several differences between these functions. (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: Convert, TSQL, Cast, SQLServer

8
Shouts

Shout it

SQL Server - Server-side paging with Row_number() function - Jacob's Blog

published 1025 days, 22 hours, 7 minutes ago posted by

jacobsebastian 1027 days, 8 hours, 52 minutes ago

If you are a programmer working with SQL Server, you must have found it little embarrassing to display information which spans across multiple pages (web pages). SQL Server 2000 did not allow you to retrieve a specific range of records, say, records 51 to 100 ordered by a certain column. (more)

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

tags: TSQL, SQLServer, server side paging

9
Shouts

Shout it

How to access a newly installed SQL Server 2008 R2 instance if you do not know the login and password

published 1027 days, 24 minutes ago posted by

jacobsebastian 1028 days, 6 hours, 50 minutes ago

This post shows a work around to access a newly installed SQL Server 2008 R2 instance in case you forgot/lost the login name and password (more)

category: Data | clicked: 6 | comment | | source: beyondrelational.com

tags: Security, DBA, SQLServer, workaround

9
Shouts

Shout it

TSQL Beginners Challenge 12 - Find the available registration dates

published 1028 days, 22 hours, 31 minutes ago posted by

jacobsebastian 1029 days, 4 hours, 15 minutes ago

This challenge involves finding available registration dates based on event schedules and registration data. Students can register for an event only for a specific period defined in "tblRegistration" table. Another table callled "tblEvent" stores the registration details which indicates the dates where a registration is made. Your job is to find the available dates where no event is registered. (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: challenges, Puzzle, TSQL, SQLServer

7
Shouts

Shout it

Bing Map Binding With SQL Server Database - Dinesh's Blog

published 1034 days, 22 hours, 41 minutes ago posted by

jacobsebastian 1035 days, 6 hours, 14 minutes ago

This post explains how to create applications that wants to display information stored in a SQL Server database on Bing Maps. (more)

category: Metro | clicked: 9 | comment | | source: beyondrelational.com

tags: Silverlight, WCF Service, Bing Maps, Bing, SQLServer

2
Shouts

Shout it

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

posted by

eralper 1035 days, 22 hours, 30 minutes ago

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure If you are planning to use OpenRowset queries in order to connet to remote database servers or if you have already implemented OpenRowset queries as a solution to remote connections as an alternative tp linked servers in Microsoft SQL Server 2005, you should first configure the database instance to enable Ad Hoc Distributed Queries in the installed SQL Server database instance where the Ad Hoc query will run. There are two ... (more)

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

| flag as spam

tags: SqlServer 2008, SQL, SQLServer, sp_configure, Ad hoc

7
Shouts

Shout it

Support for Paging Queries in SQL Server CE 4.0 - Jacob's Blog

published 1035 days, 21 hours, 42 minutes ago posted by

jacobsebastian 1036 days, 7 hours, 45 minutes ago

This post explains a new TSQL enhancement added to SQL Server CE 4.0 to support queries that require server side paging. For example, this new syntax allows you to fetch rows 31 to 40 to display on page 3 of your web page. (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: TSQL, sqlserver compact, sql server ce 4.0, SQLServer

6
Shouts

Shout it

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log - TSQL Challenges for Beginners

posted by

jacobsebastian 1046 days, 5 hours, 12 minutes ago

This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application. (more)

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

| flag as spam

tags: challenges, TSQL, puzzles, SQLServer, challenge

7
Shouts

Shout it

The Self Join – Inner Join and Outer Join - An Example

published 1047 days, 22 hours, 51 minutes ago posted by

pinaldave 1048 days, 5 hours, 37 minutes ago

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join. Read more for example. (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

8
Shouts

Shout it

Export all table data to Text file - Madhivanan's TSQL Blog

published 1047 days, 22 hours, 51 minutes ago posted by

jacobsebastian 1048 days, 7 hours, 18 minutes ago

One of my friends asked me if it is possible to export each table's data to each text file so that those files can be used in another system for data import? The point is he wanted to move database from SQL Server to Mysql. But there was not possible to have a connectivity between the two systems. He generated the script but exporting data was the problem. I suggested him to run this script that will take all userdefined table's data to each file where filename is the table name itself (more)

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

tags: TSQL, scripts, export data, SQLServer, export

4
Shouts

Shout it

Aggregate of an aggregate function in SSRS - Some Random Thoughts

published 1048 days, 22 hours, 55 minutes ago posted by

jacobsebastian 1049 days, 9 hours, 34 minutes ago

I am worse than a child when it comes to colours and no wonder, spend a lot of time on the aesthetics whenever I am preparing an Excel sheet or a PowerPoint presentation. For me, this is rather a way to indulge the child within me than to make it more presentable to the audience. The joy that you get when you arrive on that perfect colour for your headers or that perfect font to suit the mood or that perfect design template for your slides is something that can’t be expressed. Recently, I was preparing t... (more)

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

tags: Reporting, Tips and Tricks, SQLServer, SSRS

7
Shouts

Shout it

Using a UDF as a SARG. Make a hash of it! - Dave Ballantyne's Blog

published 1048 days, 22 hours, 55 minutes ago posted by

jacobsebastian 1050 days, 5 hours, 44 minutes ago

The evils and inadequacies of UDF (User Defined Functions) in SqlServer are well documented, but there is another scenario using UDF’s that will cause a lot of pain if not carefully controlled. (more)

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

tags: UDF, TSQL, Performance, SQLServer, query plan

8
Shouts

Shout it

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery - Jacob's Blog

published 1049 days, 23 hours, 6 minutes ago posted by

jacobsebastian 1051 days, 4 hours, 18 minutes ago

This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples. (more)

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

tags: xquery, XML, TSQL, SQLServer

Welcome!

SQLServer

SQL Server App_name() function - find out which application has modified your data - Madhivanan's TSQL Blog

Backup of a FILESTREAM database may include garbage files as well - Jacob's Blog

SQL SERVER – Computed Column – PERSISTED and Performance

SQL Server - Count(*) or Count(1) ? - Which is better? - Dave Ballantyne's Blog

TSQL Challenge 35 - Find the total number of 'Full Attendees' in each 24 HOP Session

Time Zone Awareness For Global Organization

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example « Journey to SQL Authority with Pinal Dave

SQL Server - Difference between TSQL Functions CAST() and CONVERT() - Madhivanan's TSQL Blog

SQL Server - Server-side paging with Row_number() function - Jacob's Blog

How to access a newly installed SQL Server 2008 R2 instance if you do not know the login and password

TSQL Beginners Challenge 12 - Find the available registration dates

Bing Map Binding With SQL Server Database - Dinesh's Blog

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

Support for Paging Queries in SQL Server CE 4.0 - Jacob's Blog

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log - TSQL Challenges for Beginners

The Self Join – Inner Join and Outer Join - An Example

Export all table data to Text file - Madhivanan's TSQL Blog

Aggregate of an aggregate function in SSRS - Some Random Thoughts

Using a UDF as a SARG. Make a hash of it! - Dave Ballantyne's Blog

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery - Jacob's Blog

Open ID Login

Standard Login

Forgot Password?

Sign up