Viewing 15 posts - 1 through 15 (of 1,169 total)
You canexec tempdb.dbo.sp_help '#temp'
and you have all details about #temp
August 15, 2018 at 7:59 am
March 22, 2018 at 1:54 pm
February 9, 2018 at 4:28 pm
Our database team is in the Development department. Other database teams of other divisions in my company also belong to the development departments.
August 9, 2017 at 8:34 am
If you have a dedicated physical server, then the licensing is tied to the number of cores.
You can have multiple licenses on the server, from many reasons. You should...
May 25, 2017 at 3:12 am
May 24, 2017 at 11:26 am
rob.lewis 86087 - Friday, May 19, 2017 8:22 AMthat will a new query plan each time though?
Not for the entire stored procedure,...
May 19, 2017 at 8:33 am
May 19, 2017 at 8:21 am
I'd restrict his access to the databases too. I won't allow him to view the tables/objects of all databases, but only to those specified.
May 19, 2017 at 8:10 am
Take a look in this post - http://www.sqlservercentral.com/blogs/si-vis-pacem-para-sql/2016/10/02/changing-sql-server-name/
May 19, 2017 at 5:01 am
May 13, 2017 at 11:23 am
May 9, 2017 at 5:50 am
Msg 3201, Level 16, State 1, Line 13
Cannot open...
May 9, 2017 at 12:52 am
May 9, 2017 at 12:33 am
Viewing 15 posts - 1 through 15 (of 1,169 total)