|
|
-
kingkong0924 Liked 9 Months ago through Blogs | 1 Point
Open connections consume server resources. If you need to frequently disconnect all your open connections to the corresponding SQL server instances from the multiple queries open in SQL Server Managment Studio (SSMS), this neat little feature built into...
|
-
kingkong0924 learned 9 Months ago through Blogs | 1 Point
Open connections consume server resources. If you need to frequently disconnect all your open connections to the corresponding SQL server instances from the multiple queries open in SQL Server Managment Studio (SSMS), this neat little feature built into...
|
|
|
|
|
-
kingkong0924 Liked 9 Months ago through Blogs | 1 Point
How do you script your database objects using T-SQL? I explore 3 different methods that I know about in this post....
|
-
kingkong0924 learned 9 Months ago through Blogs | 1 Point
How do you script your database objects using T-SQL? I explore 3 different methods that I know about in this post....
|
-
kingkong0924 Liked 10 Months ago through Blogs | 1 Point
How do you extract Day of the Year, Day of the Week and Week Number values from a given date using nothing but T-SQL? In this post, we look at how the DATEPART function can be of help in achieving this requirement....
|
-
kingkong0924 refreshed 10 Months ago through Blogs | 1 Point
How do you extract Day of the Year, Day of the Week and Week Number values from a given date using nothing but T-SQL? In this post, we look at how the DATEPART function can be of help in achieving this requirement....
|
|
|
|
|