SqlServerKudos - Stories tagged with pinaldave

pinaldave

atom rss
1
kudos
spam Kudos Remove

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave
published 764 days, 23 hours, 55 minutes ago posted by pinaldavepinaldave 774 days, 21 hours, 43 minutes ago
Monday, April 19, 2010 7:44:46 AM GMT Friday, April 09, 2010 9:56:55 AM GMT
SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave
I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. My Scenario It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB in size, and, to restore it on our production server, it usually takes around 16 to 22 minutes, depending on the load server that is usually present. This range in time varies from one ser... (more)
category: Management | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot « Journey to SQL Authority with Pinal Dave
published 768 days, 10 minutes ago posted by pinaldavepinaldave 777 days, 6 hours, 27 minutes ago
Friday, April 16, 2010 7:29:56 AM GMT Wednesday, April 07, 2010 1:12:38 AM GMT
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot « Journey to SQL Authority with Pinal Dave
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and can always reside on the same server instance as the database. Each database snapshot is consistent, in terms of transactions, with the source database as of the moment of the snapshot’s creation. A snapshot... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Generate Report for Index Physical Statistics – SSMS « Journey to SQL Authority with Pinal Dave
published 778 days, 54 minutes ago posted by pinaldavepinaldave 788 days, 48 minutes ago
Tuesday, April 06, 2010 6:45:27 AM GMT Saturday, March 27, 2010 6:51:29 AM GMT
SQL SERVER – Generate Report for Index Physical Statistics – SSMS « Journey to SQL Authority with Pinal Dave
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are similar type of reports are available at Database level, just like those available at the Server Instance level. You can right click on Database name and click Reports. Under Standard Reports, you will find following reports. Disk Usage Disk Usage b... (more)
category: Query | clicked: 5 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
published 815 days, 2 hours, 33 minutes ago posted by pinaldavepinaldave 824 days, 23 hours, 4 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: 2 | comment | | source: blog.sqlauthority.com
tags: database, pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
published 825 days, 3 hours, 15 minutes ago posted by pinaldavepinaldave 832 days, 18 hours, 27 minutes ago
Thursday, February 18, 2010 4:24:37 AM GMT Wednesday, February 10, 2010 1:12:09 PM GMT
SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave
published 859 days, 8 hours, 59 minutes ago posted by pinaldavepinaldave 865 days, 16 hours, 57 minutes ago
Thursday, January 14, 2010 10:40:40 PM GMT Friday, January 08, 2010 2:42:51 PM GMT
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that was discussed on show was about the usage of function SUBSTRING. I found the following point very valid: SUBSTRING usage limits the length of the XML to be used. I have re-written the same function with function STUFF, and it removes a... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer, XML
1
kudos
spam Kudos Remove

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server « Journey to SQL Authority with Pinal Dave
published 860 days, 9 hours, 4 minutes ago posted by pinaldavepinaldave 869 days, 4 hours, 15 minutes ago
Wednesday, January 13, 2010 10:35:43 PM GMT Tuesday, January 05, 2010 3:24:58 AM GMT
SQL SERVER – Differences in Vulnerability between Oracle and SQL Server « Journey to SQL Authority with Pinal Dave
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below:A. Microsoft development platforms are generally more error-prone and full of bugs. This (unfairly) projects the weaknesses of Microsoft’s best-known product Windows onto its other products such as SQL Server, which is a very stable and se... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth « Journey to SQL Authority with Pinal Dave
published 880 days, 10 hours, 32 minutes ago posted by pinaldavepinaldave 889 days, 13 hours, 11 minutes ago
Thursday, December 24, 2009 9:08:01 PM GMT Tuesday, December 15, 2009 6:28:16 PM GMT
SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth « Journey to SQL Authority with Pinal Dave
Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by suggesting following: Temp Table and Table Variable — both are created in TempDB and not in memory. Let us prove this concept by running the following T-SQL script. /* Check the difference between Temp Table... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Azure Start Guide – Step by Step Installation Guide « Journey to SQL Authority with Pinal Dave
published 893 days, 11 hours, 28 minutes ago posted by pinaldavepinaldave 903 days, 3 hours, 45 minutes ago
Friday, December 11, 2009 8:11:37 PM GMT Wednesday, December 02, 2009 3:54:36 AM GMT
SQL SERVER – Azure Start Guide – Step by Step Installation Guide « Journey to SQL Authority with Pinal Dave
As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at https://sql.azure.com/ Login using your Live ID Type in invitation code received from Microsoft for CTP. You can request one for your self here. Accept the TOU. Once logged it you will have to create server username and password. ... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Comma Separated Values (CSV) from Table Column « Journey to SQL Authority with Pinal Dave
published 900 days, 11 hours, 54 minutes ago posted by pinaldavepinaldave 909 days, 14 hours, 24 minutes ago
Friday, December 04, 2009 7:45:26 PM GMT Wednesday, November 25, 2009 5:15:04 PM GMT
SQL SERVER – Comma Separated Values (CSV) from Table Column « Journey to SQL Authority with Pinal Dave
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma Separated Values (CSV) from Table Column is a very common task, and we all do this many times a day. Let us see the example that I use frequently and its output. USE AdventureWorks GO -- Check Table Column SELECT Name FROM HumanResources.Shift GO -- Get CSV values SELECT SUBSTRING( (SELECT ',' + s.Name FROM HumanResources.Shift s ORDER BY s.Name FOR XML PATH('')),2,2000... (more)
category: Query | clicked: 1 | 1 comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index « Journey to SQL Authority with Pinal Dave
published 901 days, 11 hours, 59 minutes ago posted by pinaldavepinaldave 911 days, 3 hours, 32 minutes ago
Thursday, December 03, 2009 7:40:29 PM GMT Tuesday, November 24, 2009 4:07:07 AM GMT
SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index « Journey to SQL Authority with Pinal Dave
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature and I use this feature every now and then. The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one would not do the same? One of the recent conversations I had with one SQL Expert is with regard to the SSN number. The discussion was that SSN numbers are always unique and never repeated and hence ... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY « Journey to SQL Authority with Pinal Dave
published 901 days, 11 hours, 59 minutes ago posted by pinaldavepinaldave 911 days, 3 hours, 38 minutes ago
Thursday, December 03, 2009 7:40:29 PM GMT Tuesday, November 24, 2009 4:01:45 AM GMT
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY « Journey to SQL Authority with Pinal Dave
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. The error also explains the solution for the same – use of TOP. I have seen developers and DBAs using TOP very causally when they have to use the O... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Difference Between Candidate Keys and Primary Key « Journey to SQL Authority with Pinal Dave
published 928 days, 13 hours, 58 minutes ago posted by pinaldavepinaldave 938 days, 8 hours, 51 minutes ago
Friday, November 06, 2009 5:41:40 PM GMT Tuesday, October 27, 2009 10:48:09 PM GMT
SQL SERVER – Difference Between Candidate Keys and Primary Key « Journey to SQL Authority with Pinal Dave
Introduction Not long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys. Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Key... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
2
kudos
spam Kudos Remove

SQL SERVER – Introduction to Cloud Computing « Journey to SQL Authority with Pinal Dave
published 1022 days, 19 hours, 57 minutes ago posted by pinaldavepinaldave 1025 days, 1 hour, 46 minutes ago
Tuesday, August 04, 2009 11:42:41 AM GMT Sunday, August 02, 2009 5:53:49 AM GMT
SQL SERVER – Introduction to Cloud Computing « Journey to SQL Authority with Pinal Dave
Introduction “Cloud Computing,” to put it simply, means “Internet Computing.” The Internet is commonly visualized as clouds; hence the term “cloud computing” for computation done through the Internet. With Cloud Computing users can access database resources via the Internet from anywhere, for as long as they need, without worrying about any maintenance or management of actual resources. Besides, databases in cloud are very dynamic and scalable. Cloud computing is unlike grid computing, utility computin... (more)
category: News | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
published 1029 days, 19 hours, 34 minutes ago posted by pinaldavepinaldave 1030 days, 1 hour, 15 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Tuesday, July 28, 2009 6:24:13 AM GMT
SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose identity was missed (not is sequential order) within the entire database? A big thank you to SQL Server Expert, Imran Mohammed, for his excellent response to this question. He also provided an extremely impressive script, which is well descr... (more)
category: Management | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
published 1028 days, 19 hours, 28 minutes ago posted by pinaldavepinaldave 1030 days, 20 hours, 27 minutes ago
Wednesday, July 29, 2009 12:11:04 PM GMT Monday, July 27, 2009 11:12:30 AM GMT
SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose identity was missed (not is sequential order) within the entire database? A big thank you to SQL Server Expert, Imran Mohammed, for his excellent response to this question. He also provided an extremely impressive script, which is well descr... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
Previous 1 2 Next