Easy way to reseed identity column ? TIP #77
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...
2014-12-20
497 reads
Rajat Jaiswal
- Interests: I am always interested in Microsoft Technology specially asp.net & SQL server. Other than this I love Singing ,dancing and playing musical instruments.
Sequence feature TIP #76
Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...
2014-12-10
255 reads
How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75
When you do SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER...
2014-12-06
324 reads
How to disable constraints of a table ? TIP #74
You are reading this post just because of two reason
1) You are curious whether it is possible or not...
2014-11-20
263 reads
How to determine Meta data or result set information of a stored procedure /trigger ? TIP # 73
Sometimes it may require that you don’t know what will be output of a stored procedure ? what kind of result...
2014-11-19
439 reads
How to replace a specific string from a large string with Write feature ? TIP #72
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...
2014-11-14
313 reads
How explicitly insert default value ? TIP #72
Suppose, sometimes you just need entry in the table with all the default values.
For example you have a Student...
2014-11-10
204 reads
How to pause execution for particular time or interval ? TIP #71
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...
2014-11-09
277 reads
How to find all running SQL Server Instance on a machine ? TIP #70
Hello friends,
Many times it happened with me I forgot the instance name of SQL Server.
So here is a small trick...
2014-11-07
287 reads
How to copy table structure only from a SQL Query ? Tip #69
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from...
2014-11-03
695 reads
Blogs
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Cloud Databases Made Simple: Creating Your First AWS RDS Instance
I recently started full time learning of Amazon Web Services (AWS). I found that...
Forums
cluster node quarintined
evening All hoping someone can shed some light - I have a (originally) 2...
Is this version SQL Server Management Studio15.0.18424.0 buggy or...?
Maybe I'm just doing something really simple and dumb. I imported a bunch of...
C# - how to convert string to date
Hi everyone I am not too experienced using C#. I need to convert date...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers