SqlServerKudos

SQLServer

1
kudos

Kudos

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave

published 10 hours ago posted by

pinaldave 4 days, 22 hours, 30 minutes ago

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave

Just a day ago, I was reading the blog post of Michale J Swart. If you are a regular reader of this blog, I am sure you will be familiar with him. He is a very interesting blogger for sure. He recently wrote an article about Ten Things I hate to See in T-SQL; it was really fun, but the thing which caught my eyes was the subject of isDeleted Column. First of all, let me say that I totally agree with his view point. Let me re-produce what Michale exactly suggests. “Deleted records aren’t deleted. Look, th... (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Why SQL Server is better than any other RDBMS Applications?

published 17 days, 11 hours, 10 minutes ago posted by

pinaldave 26 days, 16 hours, 34 minutes ago

Why SQL Server is better than any other RDBMS Applications?

I strongly suggest that you bookmark this post as this post can be used in future when you might want to write why SQL Server is better than any other RDBMS application. (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SHRINKDATABASE For Every Database in the SQL Server

published 19 days, 11 hours, 20 minutes ago posted by

pinaldave 29 days, 1 hour, 12 minutes ago

SHRINKDATABASE For Every Database in the SQL Server

This article is an interesting story of Shrinking the Database. Do you Shrink your database - learn the story today! (more)

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

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL Server FILESTREAM feature and Differential Backups

published 27 days, 11 hours, 55 minutes ago posted by

sa 36 days, 12 hours, 46 minutes ago

SQL Server FILESTREAM feature and Differential Backups

This post tries to explain the behavior of differential backups on a FILESTREAM enabled database. A number of times, I see questions looking for a confirmation whether Differential Backups will correctly backup the NTFS (FILESTREAM) files and restore Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #DBA, #FILESTREAM, Backup, DBA, filestream, Restore, SQLServer, TSQL

1
kudos

Kudos

SQL SERVER – Computed Column – PERSISTED and Performance

published 28 days, 12 hours ago posted by

pinaldave 37 days, 13 hours, 15 minutes ago

SQL SERVER – Computed Column – PERSISTED and Performance

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: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave

published 51 days, 13 hours, 36 minutes ago posted by

pinaldave 59 days, 18 hours, 13 minutes ago

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave

I just received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the best. You can win the subscription. I will pick the winner of the subscription on 25th of the July. Which means you have 10 days to take part. I will decide the winner with the help of fellow MVPs and subject matter experts. You need to ... (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

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

published 52 days, 13 hours, 41 minutes ago posted by

pinaldave 61 days, 21 hours, 11 minutes ago

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

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: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery

published 60 days, 14 hours, 17 minutes ago posted by

sa 69 days, 13 hours, 42 minutes ago

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery

This post aims to be a quick reference source for the beginners and shows a few simple SELECT examples. Reading attributes from an XML variable DECLARE @x XML SET @x = '' Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #XML, #XQUERY, SQLServer, TSQL, XML, xquery, XQuery Functions, XQuery Lab, xquery labs, XQuery Tutorials, XQuery-Functions, xquery-lab, XQuery-Labs

1
kudos

Kudos

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

published 62 days, 14 hours, 27 minutes ago posted by

pinaldave 71 days, 2 hours, 16 minutes ago

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed below. You will be successfully able to test multiple instances of SQL Server using this tool. Once the tool is launched, select the product you wish to analysis. Click on Start Scan will take few minut... (more)

category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Statistics without Index - Possible and Helpful

published 65 days, 14 hours, 37 minutes ago posted by

pinaldave 74 days, 1 hour, 20 minutes ago

Statistics without Index - Possible and Helpful

A Simple note about the subject, how statistics can be helpful and how they are created. (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Creating reports that the end user can customize

published 69 days, 14 hours, 57 minutes ago posted by

sa 77 days, 15 hours, 22 minutes ago

Creating reports that the end user can customize

This is the 15th year in my career building serious business applications using various technologies (starting from DBase, going through Clipper, Foxpro, Visual Basic, Visual C++, and finally sticking to SQL Server) and one of the points I observed is Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #STA, Custom Reports, Izenda, reporting, SQL Tools, SQLServer, SSRS

1
kudos

Kudos

Using the XMLTable() Function

published 69 days, 14 hours, 57 minutes ago posted by

sa 78 days, 16 hours, 32 minutes ago

A few weeks back, I published a function named XMLTable() that helps to query XML documents easily. The idea behind the function is to be able to blindly query XML documents just like you do a ‘SELECT *’ on a relational table. Not only that this function Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: SQLAuthority, SQLServer, TSQL, XML, xquery

1
kudos

Kudos

The SQL Server MasterClass Experience | AdaTheDev

published 71 days, 15 hours, 7 minutes ago posted by

AdaTheDev 80 days, 18 hours, 58 minutes ago

The SQL Server MasterClass Experience | AdaTheDev

SQL Server MasterClass 2010 was a very high quality, one day event presented by Paul S. Randal and Kimberly L. Tripp - not that they need any introduction of course. In fact if you don't know of them, then perhaps you should close down your SSMS window and switch off your machine - after reading my blog of course :). Maybe uninstall SQL Server too... The A-Team With two of the best SQL Server trainers in the industry offering a packed schedule of sessions, it was an... (more)

category: Community | clicked: 0 | comment | | source: www.adathedev.co.uk

tags: DBA, SQL, SQL Server, SQLServer

1
kudos

Kudos

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

published 72 days, 15 hours, 8 minutes ago posted by

pinaldave 81 days, 41 minutes ago

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually asked if thereis any way one can know how much data in a table is stored in the memory cache? The more detailed question I usually get is if there are multiple indexes on table (and used in a query), were the data of the single table stored mu... (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

FILESTREAM directory structure - where do the GUIDs come from?

published 74 days, 15 hours, 18 minutes ago posted by

sa 83 days, 15 hours, 17 minutes ago

FILESTREAM directory structure - where do the GUIDs come from?

One of the questions that might come to your mind while getting started with FILESTREAM is the way FILESTREAM directories and files are named. Within the FILESTREAM Data Container, SQL Server creates a root folder per FILESTREAM enabled table. If the Read More......(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: DAC, filestream, SQLServer, TSQL

1
kudos

Kudos

XQuery Lab 57 – Getting Started with OPENXML

published 74 days, 15 hours, 18 minutes ago posted by

sa 83 days, 16 hours, 22 minutes ago

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

Kudos

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

published 76 days, 15 hours, 27 minutes ago posted by

jacobsebastian 84 days, 17 hours, 33 minutes ago

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

Kudos

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

published 77 days, 15 hours, 32 minutes ago posted by

jacobsebastian 86 days, 15 hours, 10 minutes ago

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

Kudos

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave

published 78 days, 15 hours, 37 minutes ago posted by

pinaldave 86 days, 19 hours, 35 minutes ago

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave

Previously, I had written a blog post about SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation. After that, I have written the following blog post that talks about the advantage and disadvantage of Shrinking and why one should not be Shrinking a file SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008. On this subject, SQL Server Expert Imran Mohammed left an excellent comment. I just feel that his comment is worth a big article itself. For everybody to read his wonderful explanatio... (more)

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

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

published 78 days, 15 hours, 37 minutes ago posted by

jacobsebastian 87 days, 15 hours, 11 minutes ago

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

Welcome!

SQLServer

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave

Why SQL Server is better than any other RDBMS Applications?

SHRINKDATABASE For Every Database in the SQL Server

SQL Server FILESTREAM feature and Differential Backups

SQL SERVER – Computed Column – PERSISTED and Performance

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave

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

XQuery Lab 62 – Revisiting simple TSQL SELECT operations using XQuery

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

Statistics without Index - Possible and Helpful

Creating reports that the end user can customize

Using the XMLTable() Function

The SQL Server MasterClass Experience | AdaTheDev

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

FILESTREAM directory structure - where do the GUIDs come from?

XQuery Lab 57 – Getting Started with OPENXML

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

Open ID Login

Standard Login

Forgot Password?

Sign up