Viewing 15 posts - 1 through 15 (of 1,170 total)
You canexec tempdb.dbo.sp_help '#temp'
and you have all details about #temp
Igor Micev
August 15, 2018 at 7:59 am
Igor Micev
March 22, 2018 at 1:54 pm
Igor Micev
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.
Igor Micev
August 9, 2017 at 8:34 am
Igor Micev
May 25, 2017 at 3:47 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...
Igor Micev
May 25, 2017 at 3:12 am
Igor Micev
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,...
Igor Micev
May 19, 2017 at 8:33 am
Igor Micev
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.
Igor Micev
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/
Igor Micev
May 19, 2017 at 5:01 am
Igor Micev
May 13, 2017 at 11:23 am
Igor Micev
May 9, 2017 at 5:50 am
Msg 3201, Level 16, State 1, Line 13
Cannot open...
Igor Micev
May 9, 2017 at 12:52 am
Igor Micev
May 9, 2017 at 12:33 am
Viewing 15 posts - 1 through 15 (of 1,170 total)