Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Utility
Quite often I get the request regarding how to copy all the objects – including schema and data from any database and re-create it on another instance. SQL Server 2008 and SQL Server 2008 R2 has script generator wizard which does it for us. I ask you to pay special…
Read More

SQL SERVER – Cartoon Challenge – 140 Character Winner is Here

Pinal Dave
Personal, SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
Database, MVP, SQL Scripts
Earlier Idera has announced contest where participant can win Windows Mobile Phone by writing 140 character. Here is the details of the contest SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL. We received more than 200 comments on the blog post…
Read More

SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Table Operation

I have been working with the database for many years and I am aware of many common terminologies. Recently I was attending training myself and the instructor used the word ‘CTAS’ in the class. One of the attendees did not know the definition of this abbreviation. From this, I realized that not all of us come from the same background and we all have different levels and areas of expertise.

Read More