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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy