| ||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||
Gopal, your password was successfully reset
Tuesday 2 December 2014
Gopal, your password was successfully reset
Wednesday 17 September 2014
| ||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||
Gopal, here's the link to reset your password
| ||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||
I'd like to add you to my professional network on LinkedIn
Monday 15 September 2014
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
creating an Identity column
Tuesday 1 March 2011
This will create an identity column in the following table.CREATE TABLE dbo.MyTable ( ID INT IDENTITY(1,1) ,MyShortDesc varchar(20) ,MyLongDesc varchar(500) );
Data file locations
Thursday 3 June 2010
Here's a query which displays the .mdf and .ldf location of all the databases in the server.
SELECT physical_name
FROM master.sys.master_files
Sequence number within a group
Saturday 10 April 2010
The following query can be used to generate the sequence numbers within a group.
select
GROUP_ID
, GROUP_COUNTER= ROW_NUMBER()
OVER ( PARTITION BY [GROUP_ID]
ORDER BY [GROUP_ID]
)
from GROUP_TABLE
This query can generate a output like the following.
GROUP_ID GROUP_COUNTER
-------------------------------------------
AAA 1
AAA 2
AAA 3
BBB 1
BBB 2
CCC 1
SQL Server Video tutorials
Tuesday 20 October 2009
There are some good video tutorials available here.Check it out.
An interesting article - Selecting Duplicate Rows in a table
Sunday 18 October 2009
Hi All, we are back after a pause.Here's an interesting article which talks about the different ways of selecting the duplicate rows from a table.Hope it will be useful to you.
Article
Question of the day
Friday 25 September 2009
Can you instantiate a COM object by using T-SQL?
1. True
2. False
T-SQL best practices - 4
Wednesday 23 September 2009
-Use table aliasing, even if there is no joining in the query. Aliasing eliminates ambiguity, eases subsequent modification, and further reduces the chance of a typo not being recognized.
-When querying a table, prefix it with the owner (schema), typically dbo. There is a little performance improvement and query becomes more readable
- The dynamic SQL Performs slower because the optimizer has to create an execution plan for every execution.
-Use table aliasing, even if there is no joining in the query. Aliasing eliminates ambiguity, eases subsequent modification, and further reduces the chance of a typo not being recognized.
-When querying a table, prefix it with the owner (schema), typically dbo. There is a little performance improvement and query becomes more readable
Question of the Day
What are the disadvantages of cursors?
1. Cursor results in a network roundtrip
2. Cursor requires more resources and temporary storage
3. Cursor results in more IO operations
4. 1 & 2
5. 1, 2 & 3
6. None
T-SQL best practices - 3
Tuesday 22 September 2009
Today's tips are not really related to T-SQL,but I hope these will improve the way you approach SQL SERVER.
- Get Certified
- Subscribe to News Groups and blogs to get regular updates
- Read White papers
T-SQL best practices - 2
Monday 21 September 2009
Today's best practice techniques are
- NOLOCK helps in concurrency and performance but can be dangerous for data integrity
- Use XML datatype to pass table valued parameters to procedures.
- Use SQL Server Management Console with integrated Source Control to do the development
T-SQL best practices - 1
Sunday 20 September 2009
Hi All!...we decided to write some posts on the best practices in writing T-SQL,which we think helpful to the newbies.We will list three best practices each day for the next seven days and hope this series will be helpful to all the readers.So today's best practices tips are,
Document your database
–Use Extended properties of the table structures to document the database.
–Use tools to generate the documentation and correct where necessary
–Maintain the script for populating the extended properties.
Use Cursors only when
–You cannot find a set based solution in 4 Hours
–You want to utilize already existing logic in other SP
–You are writing a database maintenance task
Use STATISTICS IO ON
–This will reduce the logical reads
We need your comments on this post and share the best practices that you are using in the script(related to the above 3 techniques).
Subscribe to:
Posts (Atom)