SqlServerKudos

SQL

1
kudos

Kudos

Loads of things going on at #SQLBits

published 46 days, 22 hours, 28 minutes ago posted by

sa 48 days, 23 hours, 33 minutes ago

Wow its been a busy few weeks in SQLBits land. Session Voting We’ve opened up voting for the sessions for SQLBits 10 http://sqlbits.com/information/PublicSessions.aspx Make sure you vote so we pick the sessions you want. You’ve got to register on the...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: SQL, SQLBits

1
kudos

Kudos

GROUPING SETS in SQL Server | AdaTheDev

published 376 days, 23 hours, 14 minutes ago posted by

AdaTheDev 386 days, 12 hours, 36 minutes ago

Something I personally haven't seen a lot of out there in the SQL Server world, is use of GROUPING SETS - an operator that can be applied in a GROUP BY clause. So what does it do? How would you use it? (more)

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

tags: grouping sets, SQL

1
kudos

Kudos

SQL SERVER – Copy Statistics from One Server to Another Server

published 386 days, 23 hours, 59 minutes ago posted by

pinaldave 395 days, 25 minutes ago

SQL SERVER – Copy Statistics from One Server to Another Server

A very efficient way of copying database statistics from one server to another server without moving data. (more)

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

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Known Unknown of System Stored Procedure of sys.sp_tables

published 466 days, 6 hours, 28 minutes ago posted by

pinaldave 475 days, 11 hours, 7 minutes ago

Known Unknown of System Stored Procedure of sys.sp_tables

Do you know even simple query like sys.tables can kill the performance of your system. There are better thing to use: Read more... (more)

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

tags: pinaldave, SQL, SQLAuthority, SQLServer

2
kudos

Kudos

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

published 510 days, 9 hours, 28 minutes ago posted by

pinaldave 517 days, 22 hours, 13 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 530 days, 10 hours, 53 minutes ago posted by

pinaldave 539 days, 16 hours, 17 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: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SHRINKDATABASE For Every Database in the SQL Server

published 532 days, 11 hours, 3 minutes ago posted by

pinaldave 542 days, 55 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: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Passing a TABLE variable into dynamic SQL | AdaTheDev

published 533 days, 11 hours, 8 minutes ago posted by

AdaTheDev 542 days, 20 hours, 37 minutes ago

Passing a TABLE variable into dynamic SQL | AdaTheDev

A question popped up on StackOverflow today, asking how to pass a TABLE variable into a dynamic SQL statement in SQL Server 2008. I've previously blogged about table-valued parameters, comparing the approach of passing in a TABLE of values to a stored procedure to the techniques you'd have had to use in earlier versions of SQL Server (e.g. CSV or XML), but this specific question is worth a quick follow-up. (more)

category: Query | clicked: 1 | comment | | source: www.adathedev.co.uk

tags: SQL, SQL Server

1
kudos

Kudos

SQL SERVER – Computed Column – PERSISTED and Performance

published 541 days, 11 hours, 43 minutes ago posted by

pinaldave 550 days, 12 hours, 58 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 564 days, 13 hours, 19 minutes ago posted by

pinaldave 572 days, 17 hours, 56 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 565 days, 13 hours, 24 minutes ago posted by

pinaldave 574 days, 20 hours, 54 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: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

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

published 575 days, 14 hours, 10 minutes ago posted by

pinaldave 584 days, 1 hour, 59 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 578 days, 14 hours, 20 minutes ago posted by

pinaldave 587 days, 1 hour, 3 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

The SQL Server MasterClass Experience | AdaTheDev

published 584 days, 14 hours, 50 minutes ago posted by

AdaTheDev 593 days, 18 hours, 40 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 585 days, 14 hours, 51 minutes ago posted by

pinaldave 594 days, 24 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

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

published 591 days, 15 hours, 20 minutes ago posted by

pinaldave 599 days, 19 hours, 18 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

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

published 596 days, 15 hours, 45 minutes ago posted by

pinaldave 606 days, 5 minutes ago

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

A few days ago, I received following email: “Pinal, We are in an emergency situation. We have a large database of around 80+ GB and its backup is of 50+ GB in size. We need to restore this database ASAP and use it; however, restoring the database takes forever. Do you think a compressed backup would solve our problem? Any other ideas you got?” First of all, the asker has already answered his own question. Yes; I have seen that if you are using a compressed backup, it takes lesser time when you try to ... (more)

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

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges

published 602 days, 16 hours, 11 minutes ago posted by

jacobsebastian 611 days, 21 hours, 52 minutes ago

TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges

This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession. Your job is to provide this synthesis using all the other information in that database described below. In particular, we are interested in... (more)

category: Query | clicked: 7 | comment | | source: beyondrelational.com

tags: puzzles, SQL, SQLServer, TSQL, tsql challenges

1
kudos

Kudos

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

published 603 days, 16 hours, 16 minutes ago posted by

pinaldave 612 days, 2 hours, 37 minutes ago

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

http://blog.sqlauthority.com/2010/06/02/sql-server-stored-procedure-and-transactions/ (more)

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

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Optimising wildcard prefixed LIKE conditions | AdaTheDev

published 610 days, 16 hours, 47 minutes ago posted by

AdaTheDev 619 days, 19 hours, 42 minutes ago

Optimising wildcard prefixed LIKE conditions | AdaTheDev

An overview on how to use indexed computed columns to optimise the performance wildcard prefixed LIKE conditions within an SQL query. (more)

category: Query | clicked: 2 | comment | | source: www.adathedev.co.uk

tags: Optimization, Performance, SQL, SQLServer

Welcome!

SQL

Loads of things going on at #SQLBits

GROUPING SETS in SQL Server | AdaTheDev

SQL SERVER – Copy Statistics from One Server to Another Server

Known Unknown of System Stored Procedure of sys.sp_tables

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

Passing a TABLE variable into dynamic SQL | AdaTheDev

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

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

Statistics without Index - Possible and Helpful

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

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

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

Optimising wildcard prefixed LIKE conditions | AdaTheDev

Open ID Login

Standard Login

Forgot Password?

Sign up