|
|
-
Johan Bijnens Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Johan Bijnens Commented 1 Years ago through Just Learned
Apparently **Cumulative Update 5 for SQL Server 2008 R2 SP1** has a **fix** for this bug ...
It's been known for ages @@identity should be avoided and scope_identity() is more stable.
ref: http://sqlblog.com/blogs/aaron_bertrand/archive/2012/02/23/...
|
-
Johan Bijnens Commented 1 Years ago through Just Learned
Apparently **Cumulative Update 5 for SQL Server 2008 R2 SP1** has a **fix** for this bug ...
It's been known for ages @@identity should be avoided and scope_identity() is more stable.
ref: http://sqlblog.com/blogs/aaron_bertrand/archive/2012/02/23/...
|
-
Johan Bijnens Answered 2 Years ago through Quizzes
Because we like scripting ! #powershell is awesome because a simple ref open the whole world ! ( not only SQLServer ) So you can use the same scripting language to do all your stuff ( no more need to write .net code compile and deploy it where needed. J...
|
-
Johan Bijnens knew 2 Years ago through Just Learned
The shortcut is, open SQL Server help file. On the top of right side, there is an option for url. Type the site url there and press enter. The page will get opened without opening any browser......
|
-
Johan Bijnens knew 2 Years ago through Just Learned
The shortcut is, open SQL Server help file. On the top of right side, there is an option for url. Type the site url there and press enter. The page will get opened without opening any browser......
|
-
Johan Bijnens Commented 2 Years ago through Just Learned
Indeed, don't promote functions on columns in where clauses.
Use foldable expressions in stead as **RamiReddy D** showed....
|
-
Johan Bijnens Commented 2 Years ago through Just Learned
Indeed, don't promote functions on columns in where clauses.
Use foldable expressions in stead as **RamiReddy D** showed....
|
-
Johan Bijnens Commented 2 Years ago through Just Learned
Indeed, don't promote functions on columns in where clauses.
Use foldable expressions in stead as **RamiReddy D** showed....
|