tag:blogger.com,1999:blog-637190736454740542024-01-12T02:19:53.718-08:00Share Your ArticleShare and Publish your Article here Instantly, and Grow your Article Audience.
This service is totally free. So Start Sharing Now.
Unknownnoreply@blogger.comBlogger2207125tag:blogger.com,1999:blog-63719073645474054.post-67920974738967747502013-09-21T20:13:00.001-07:002013-09-21T20:13:05.025-07:00SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>UPDATE : SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database This is very long query. Optionally, we can limit the query to return results for one or more than one table. SELECT K_Table = FK.TABLE_NAME, FK_Column = CU.COLUMN_NAME, PK_Table = PK.TABLE_NAME, PK_Column = PT.COLUMN_NAME, Constraint_Name = C.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C INNER JOIN… <a href='http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/11/01/sql-server-query-to-display-foreign-key-relationships-and-name-of-the-constraint-for-each-table-in-database/' target='_blank'>SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-30466471322345603472013-09-21T20:12:00.013-07:002013-09-21T20:12:55.345-07:00SQL SERVER – Query to Find ByteSize of All the Tables in Database | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SELECT CASE WHEN (GROUPING(sob.name)=1) THEN 'All_Tables'    ELSE ISNULL(sob.name, 'unknown') END AS Table_name,    SUM(sys.length) AS Byte_Length FROM sysobjects sob, syscolumns sys WHERE sob.xtype='u' AND sys.id=sob.id GROUP BY sob.name WITH CUBE Reference : Pinal Dave (http://blog.SQLAuthority.com) <a href='http://blog.sqlauthority.com/2006/11/10/sql-server-query-to-find-byte-size/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/11/10/sql-server-query-to-find-byte-size/' target='_blank'>SQL SERVER – Query to Find ByteSize of All the Tables in Database | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-75014880517404545892013-09-21T20:12:00.011-07:002013-09-21T20:12:50.709-07:00SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>I always mark fields to be deprecated with "dep_" as prefix. In this way, after few days, when I am sure that I do not need the field any more I run the query to auto generate the deprecation script. The script also checks for any constraint in the system and auto generate the script… <a href='http://blog.sqlauthority.com/2006/11/20/sql-server-auto-generate-script-to-delete-deprecated-fields-in-current-database/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/11/20/sql-server-auto-generate-script-to-delete-deprecated-fields-in-current-database/' target='_blank'>SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-38288189863148526112013-09-21T20:12:00.009-07:002013-09-21T20:12:46.119-07:00SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>Following cursor query runs through database and find all the table with certain prefixed ('b_','delete_'). It also checks if the Table is more than certain days old or created before certain days, it will delete it. We can have any other opertation on that table like delete, print or reindex. SET NOCOUNT ON DECLARE @lcl_name… <a href='http://blog.sqlauthority.com/2006/11/30/sql-server-cursor-to-process-tables-in-database-with-static-prefix-and-date-created/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/11/30/sql-server-cursor-to-process-tables-in-database-with-static-prefix-and-date-created/' target='_blank'>SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-63743716259720710322013-09-21T20:12:00.007-07:002013-09-21T20:12:38.137-07:00SQL SERVER – Cursor to Kill All Process in Database | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>When you run the script please make sure that you run it in different database then the one you want all the processes to be killed. CREATE TABLE #TmpWho (spid INT, ecid INT, status VARCHAR(150), loginame VARCHAR(150), hostname VARCHAR(150), blk INT, dbname VARCHAR(150), cmd VARCHAR(150)) INSERT INTO #TmpWho EXEC sp_who DECLARE @spid INT DECLARE @tString VARCHAR(15) DECLARE… <a href='http://blog.sqlauthority.com/2006/12/01/sql-server-cursor-to-kill-all-process-in-database/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/12/01/sql-server-cursor-to-kill-all-process-in-database/' target='_blank'>SQL SERVER – Cursor to Kill All Process in Database | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-7633093383150648572013-09-21T20:12:00.005-07:002013-09-21T20:12:33.484-07:00SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>Following code will help to find all the Stored Procedures (SP) which are related to one or more specific tables. sp_help and sp_depends does not always return accurate results. ----Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%tablename%' ----Option 2 SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id=o.id WHERE c.TEXT LIKE… <a href='http://blog.sqlauthority.com/2006/12/10/sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/12/10/sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure/' target='_blank'>SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-60425126871471477462013-09-21T20:12:00.003-07:002013-09-21T20:12:23.964-07:00SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved. | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>To fix the error which occurs after the Windows server name been changed, when trying to update or delete the jobs previously created in a SQL Server 2000 instance, or attaching msdb database. Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job… <a href='http://blog.sqlauthority.com/2006/12/20/sql-server-fix-error-14274-cannot-add-update-or-delete-a-job-or-its-steps-or-schedules-that-originated-from-an-msx-server-the-job-was-not-saved/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/12/20/sql-server-fix-error-14274-cannot-add-update-or-delete-a-job-or-its-steps-or-schedules-that-originated-from-an-msx-server-the-job-was-not-saved/' target='_blank'>SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved. | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-47885589564872460712013-09-21T20:12:00.001-07:002013-09-21T20:12:15.835-07:00SQL SERVER – Shrinking Truncate Log File – Log Full | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>UPDATE: Please follow link for SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008. Sometime, it looks impossible to shrink the Truncated Log file. Following code always shrinks the Truncated Log File to minimum size possible. USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO [Update:… <a href='http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/' target='_blank'>SQL SERVER – Shrinking Truncate Log File – Log Full | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-62804047572896846632013-09-21T20:11:00.013-07:002013-09-21T20:11:58.762-07:00SQL SERVER – Simple Example of Cursor | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>UPDATE: For working example using AdventureWorks visit : SQL SERVER - Simple Example of Cursor - Sample Cursor Part 2 This is the simplest example of the SQL Server Cursor. I have used this all the time for any use of Cursor in my T-SQL. DECLARE @AccountID INT DECLARE @getAccountID CURSOR SET @getAccountID = CURSOR FOR SELECT… <a href='http://blog.sqlauthority.com/2007/01/01/sql-server-simple-example-of-cursor/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/01/01/sql-server-simple-example-of-cursor/' target='_blank'>SQL SERVER – Simple Example of Cursor | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-58410881084415941242013-09-21T20:11:00.011-07:002013-09-21T20:11:46.577-07:00SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>USE DatabaseName GO CREATE TABLE #temp ( table_name sysname , row_count INT, reserved_size VARCHAR(50), data_size VARCHAR(50), index_size VARCHAR(50), unused_size VARCHAR(50)) SET NOCOUNT ON INSERT #temp EXEC sp_msforeachtable 'sp_spaceused ''?''' SELECT a.table_name, a.row_count, COUNT(*) AS col_count, a.data_size FROM #temp a INNER JOIN information_schema.columns b ON a.table_name collate database_default = b.table_name collate database_default GROUP BY a.table_name, a.row_count, a.data_size ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC DROP TABLE #temp… <a href='http://blog.sqlauthority.com/2007/01/10/sql-server-query-to-find-number-rows-columns-bytesize-for-each-table-in-the-current-database-find-biggest-table-in-database/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/01/10/sql-server-query-to-find-number-rows-columns-bytesize-for-each-table-in-the-current-database-find-biggest-table-in-database/' target='_blank'>SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-84453045651668619332013-09-21T20:11:00.009-07:002013-09-21T20:11:30.103-07:00SQL SERVER – Query Analyzer Shortcuts | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>Download Query Analyzer Shortcuts (PDF) Shortcut Function Shortcut Function ALT+BREAK Cancel a query CTRL+SHIFT+F2 Clear all bookmarks ALT+F1 Database object information CTRL+SHIFT+INSERT Insert a template ALT+F4 Exit CTRL+SHIFT+L Make selection lowercase CTRL+A Select all CTRL+SHIFT+M Replace template parameters CTRL+B Move the splitter CTRL+SHIFT+P Open CTRL+C Copy CTRL+SHIFT+R Remove comment CTRL+D Display results in grid format… <a href='http://blog.sqlauthority.com/2007/01/20/sql-server-query-analyzer-shortcuts/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/01/20/sql-server-query-analyzer-shortcuts/' target='_blank'>SQL SERVER – Query Analyzer Shortcuts | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-58822918404971891962013-09-21T20:11:00.007-07:002013-09-21T20:11:23.756-07:00SQL SERVER – CASE Statement/Expression Examples and Explanation | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions. Two basic formulations for CASE expression 1) Simple CASE expressions A simple CASE expression… <a href='http://blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/' target='_blank'>SQL SERVER – CASE Statement/Expression Examples and Explanation | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-35727749904416736782013-09-21T20:11:00.005-07:002013-09-21T20:11:14.378-07:00SQL SERVER – 64 bit Architecture and White Paper | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>In supportability, manageability, scalability, performance, interoperability, and business intelligence, SQL Server 2005 provides far richer 64-bit support than its predecessor. This paper describes these enhancements. Read the original paper here. Following abstract is taken from the same paper. Another interesting article on 64-bit Computing with SQL Server 2005 is here. The primary differences between the… <a href='http://blog.sqlauthority.com/2007/04/14/sql-server-64-bit-architecture-and-white-paper/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/14/sql-server-64-bit-architecture-and-white-paper/' target='_blank'>SQL SERVER – 64 bit Architecture and White Paper | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-49283230929620708372013-09-21T20:11:00.003-07:002013-09-21T20:11:09.903-07:00SQL Server Interview Questions and Answers – Introduction | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. Hello All, Thank you all for sending request for Interview Questions and Answers. It begins from today. This is six part series. I will update this post once… <a href='http://blog.sqlauthority.com/2007/04/15/sql-server-interview-questions-and-answers-introduction/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/15/sql-server-interview-questions-and-answers-introduction/' target='_blank'>SQL Server Interview Questions and Answers – Introduction | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-41673895287246149602013-09-21T20:11:00.001-07:002013-09-21T20:11:00.366-07:00SQL Server Interview Questions and Answers – Part 1 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that… <a href='http://blog.sqlauthority.com/2007/04/15/sql-server-interview-questions/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/15/sql-server-interview-questions/' target='_blank'>SQL Server Interview Questions and Answers – Part 1 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-76348240923854630442013-09-21T20:10:00.015-07:002013-09-21T20:10:51.145-07:00SQL Server Interview Questions and Answers – Part 2 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. What is the difference between clustered and a non-clustered index? A clustered index is… <a href='http://blog.sqlauthority.com/2007/04/16/sql-server-interview-questions-part-2/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/16/sql-server-interview-questions-part-2/' target='_blank'>SQL Server Interview Questions and Answers – Part 2 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-77096403864847505792013-09-21T20:10:00.013-07:002013-09-21T20:10:44.216-07:00SQL Server Interview Questions and Answers – Part 3 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. What is a NOLOCK? Using the NOLOCK query optimiser hint is generally considered good… <a href='http://blog.sqlauthority.com/2007/04/17/sql-server-interview-questions-part-3/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/17/sql-server-interview-questions-part-3/' target='_blank'>SQL Server Interview Questions and Answers – Part 3 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-63004993945784495942013-09-21T20:10:00.011-07:002013-09-21T20:10:38.646-07:00SQL Server Interview Questions and Answers – Part 4 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. What is SQL Profiler? SQL Profiler is a graphical tool that allows system administrators… <a href='http://blog.sqlauthority.com/2007/04/18/sql-server-interview-questions-part-4/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/18/sql-server-interview-questions-part-4/' target='_blank'>SQL Server Interview Questions and Answers – Part 4 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-78201937694382118822013-09-21T20:10:00.009-07:002013-09-21T20:10:34.004-07:00SQL Server Interview Questions and Answers – Part 5 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. What command do we use to rename a db? sp_renamedb ‘oldname’ , ‘newname’ If… <a href='http://blog.sqlauthority.com/2007/04/19/sql-server-interview-questions-part-5/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/19/sql-server-interview-questions-part-5/' target='_blank'>SQL Server Interview Questions and Answers – Part 5 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-13230468153031422232013-09-21T20:10:00.007-07:002013-09-21T20:10:29.252-07:00SQL Server Interview Questions and Answers – Part 6 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. What are the properties of the Relational tables? Relational tables have six properties: Values… <a href='http://blog.sqlauthority.com/2007/04/20/sql-server-interview-questions-part-6/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/20/sql-server-interview-questions-part-6/' target='_blank'>SQL Server Interview Questions and Answers – Part 6 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-5343960649249690822013-09-21T20:10:00.005-07:002013-09-21T20:10:21.932-07:00SQL Server Interview Questions and Answers Complete List Download | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters UPDATE : Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers. New Location : SQL Server 2008 Interview Questions and Answers. Download SQL Server Interview Questions and Answers Complete List Thank you all for your… <a href='http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/' target='_blank'>SQL Server Interview Questions and Answers Complete List Download | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-33499236940500088662013-09-21T20:10:00.003-07:002013-09-21T20:10:10.314-07:00SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>Error: 1418 - Microsoft SQL Server - The server network address can not be reached or does not exist. Check the network address name and reissue the command The server network endpoint did not respond because the specified server network address cannot be reached or does not exist. Fix/Workaround/Solution: Step 1) Your system Firewall should… <a href='http://blog.sqlauthority.com/2007/04/22/sql-server-fix-error-1418-microsoft-sql-server-the-server-network-address-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-reissue-the-command/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/22/sql-server-fix-error-1418-microsoft-sql-server-the-server-network-address-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-reissue-the-command/' target='_blank'>SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-86707018418370267662013-09-21T20:10:00.001-07:002013-09-21T20:10:01.572-07:00SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>The master database's syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as first day of the week using SET DATEFIRST 5 This will… <a href='http://blog.sqlauthority.com/2007/04/22/sql-server-datefirst-and-set-datefirst-relations-and-usage/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/22/sql-server-datefirst-and-set-datefirst-relations-and-usage/' target='_blank'>SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-91594633709379689442013-09-21T20:09:00.001-07:002013-09-21T20:09:50.988-07:00SQL SERVER – Raid Configuration – RAID 10 | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>I get question about what configuration of redundant array of inexpensive disks (RAID) I use for my SQL Servers. The answer is short is: RAID 10. Why? Excellent performance with Read and Write. RAID 10 has advantage of both RAID 0 and RAID 1. RAID 10 uses all the drives in the array to gain… <a href='http://blog.sqlauthority.com/2007/04/22/sql-server-raid-configuration-raid-10/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/22/sql-server-raid-configuration-raid-10/' target='_blank'>SQL SERVER – Raid Configuration – RAID 10 | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-63719073645474054.post-71838031650835286882013-09-21T01:09:00.001-07:002013-09-21T01:09:06.602-07:00SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index | Journey to SQL Authority with Pinal Dave<div><a href='http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200'><img src=http://0.gravatar.com/blavatar/08e35387c05b61340e885b1763a69d9f?s=200 /></a></div>Clustered Index Only 1 allowed per table Physically rearranges the data in the table to conform to the index constraints For use on columns that are frequently searched for ranges of data For use on columns with low selectivity Non-Clustered Index Up to 249 allowed per table Creates a separate list of key values with… <a href='http://blog.sqlauthority.com/2007/04/23/sql-server-understanding-new-index-type-of-sql-server-2005-included-column-index-along-with-clustered-index-and-non-clustered-index/' target='_blank'>Continue Reading...</a><br/><br/><b>Source:</b> <a href='http://blog.sqlauthority.com/2007/04/23/sql-server-understanding-new-index-type-of-sql-server-2005-included-column-index-along-with-clustered-index-and-non-clustered-index/' target='_blank'>SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index | Journey to SQL Authority with Pinal Dave</a>Unknownnoreply@blogger.com0