|
|
pinaldave
Stories submitted by pinaldave
|
|
submitted by
 pinaldave
6 days, 20 hours ago blog.sqlauthority.com — If you have struggled with your datetime format with your application or database. This is one script you will need.
Bookmark it. read more...
add a comment
|
category:  Database | Views: 4
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 15 days, 22 hours ago, submitted by
pinaldave
17 days, 6 hours ago blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times.
When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible.
Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...
3 comments
|
category: Database | Views: 235
| 
|
tags:
SQL, SQLServer, SQLAuthority, Database, 2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
17 days, 19 hours ago blog.sqlauthority.com — Let us try to understand this subject with example.
We will use Adventurworks database for this purpose. Table which we will be using are HumanResources.Employee (290 rows), HumanResources.EmployeeDepartmentHistory (296 rows) and HumanResources.Department (16 rows).
We will be running following two queries and observe the output. In the resultset the order of first column (EmployeeID) is different in both the cases when whole resultset is same. When compared both the results they are same but the order of rows is different in both the resultset. read more...
add a comment
|
category: Database | Views: 6
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 3 months, 23 days ago, submitted by
pinaldave
3 months, 23 days ago blog.sqlauthority.com — One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion.
Download SQL Server FAQ Sheet in PDF format
read more...
4 comments
|
category: Database | Views: 108
| 
|
tags:
SQLAuthority, SQLServer, Database, SqlServer2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
3 months, 27 days ago blog.sqlauthority.com — What is your opinion about it and why?
If you have no opinion then read other readers opinion. read more...
1 comment
|
category: Database | Views: 5
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 4 months, 6 days ago, submitted by
pinaldave
4 months, 7 days ago blog.sqlauthority.com — I have written 14 best practices here, read them all and let me know what is as per your opinion should be the 15th best practice. read more...
3 comments
|
category: Database | Views: 9
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 5 months, 17 days ago, submitted by
pinaldave
5 months, 17 days ago blog.sqlauthority.com — UNION ALL does not work all the time.
There is great discussion about it. If you have any suggestion, please provide it. read more...
4 comments
|
category: Database | Views: 10
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 5 months, 25 days ago, submitted by
pinaldave
5 months, 25 days ago blog.sqlauthority.com — This articles offers one honest fact about SELECT 1 vs SELECT * - however it lacks conclusion - your opinion matters. read more...
1 comment
|
category: Database | Views: 4
| 
|
tags:
SQL, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
6 months, 10 days ago blog.sqlauthority.com — SQL Server 2008 Brochure is available to download. It contains many information like available Server Editions, Top New Features, New Available Technologies and additional resources. read more...
add a comment
|
category: Database | Views: 0
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
7 months, 12 days ago blog.sqlauthority.com — DBA have been referencing database objects in four part names. SQL Server 2005 introduces the concept of a synonym. A synonyms is a single-part name which can replace multi part name in SQL Statement. Use of synonyms cuts down typing long multi part server name and can replace it with one synonyms. It also provides an abstractions layer which will protect SQL statement using synonyms from changes in underlying objects (tables etc). read more...
add a comment
|
category: Database | Views: 0
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
7 months, 14 days ago blog.sqlauthority.com — Each question is very unique to each individual and its answer can be very different from person to person. There is no right or wrong answer here. Just answer what you feel right. read more...
1 comment
|
category:  Community | Views: 32
| 
|
tags:
Community | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
8 months, 17 days ago blog.sqlauthority.com — Notes about usergroup meeting as well interesting read about Top 10 reasons companies outsource. read more...
add a comment
|
category:  Events | Views: 0
| 
|
| tag it
Everyones tags: | Your tags: | |
No tags
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|