Viewing 15 posts - 181 through 195 (of 13,456 total)
without access to SQL, no you cannot find out.
if you have access to view server state, the DMV's for index stats has the last time an index was used to...
June 7, 2019 at 8:39 pm
a pair of examples. if you are only looking for items that are 6 chars and start with P, vs stuffing a bunch of zeros into it no matter what...
June 6, 2019 at 9:13 pm
i prefer the alter authorization command:
ALTER AUTHORIZATION ON DATABASE::[WSS_Content] to [MyDomain\SharePointServiceAccount];
June 4, 2019 at 7:29 pm
i think you need to execute a script after the dacpac deployment.
a dacpac will create tables and objects, but there's no scripting involved, so no, no script can be appended...
June 3, 2019 at 8:57 pm
holy crap the new format of the website plays holy hell with code i took a lot of time to comment well and make sharp looking.
June 1, 2019 at 12:36 am
here is an older example i used to use, that assumes you have a list of server sin Central Management Servers
for each server, i may run a query per server,...
June 1, 2019 at 12:35 am
the six month/180 day evaluation is not that painful in a lab.
it is great practice to build machines over and over, join them to your lab's domain, and ideally, you...
May 9, 2019 at 2:04 pm
oops i missed the variable value request.
you need the data type and the value:
$node.VariableValue.DataType
$node.VariableValue.'#text'
May 9, 2019 at 12:49 pm
this was an interesting request for me.
i was able to do to this via powershell and shredding the xml of each dtsx package.
the script below scans a whole folder and...
May 9, 2019 at 12:42 pm
auditing inserts is "excessively repetitively redundant", i would only audit updates and deletes, as you have the original data in the table, if no updates occurred. do you REALLY need...
May 8, 2019 at 8:20 pm
I may be jaded on this one.
I have seen three separate start-and-fail-to-implement initiatives to use Master Data Management at my current work location,and a total of half a dozen implementations...
April 24, 2019 at 2:02 pm
first thing i would look at was HEAP tables. unless you get a table lock, you could have rows that were deleted but never returned their space back to the...
April 22, 2019 at 9:09 pm
San_kan1gb;
I believe this article was reposted from the original~12 years ago, i'll see if i can recover the links. the proc has gone through a slew of changes since then..matching...
April 16, 2019 at 10:53 am
Express editions have a setting called autoclose, which turns off the database when it has been idle for a while in order to save resources, since an express edition is...
April 10, 2019 at 12:55 pm
no.
you can never restore a database from a higher version of SQL to a lower version. you will need to upgrade your 2014 instances to be 2017 as well.
a database...
April 10, 2019 at 12:24 pm
Viewing 15 posts - 181 through 195 (of 13,456 total)