DBA relationships – The data custodian
G’day,
As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right...
2011-04-28
2,271 reads
G’day,
As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right...
2011-04-28
2,271 reads
G’day,
There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply...
2011-04-27
14,633 reads
G’day,
A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as...
2011-04-27
2,655 reads
G’day,
I’ve blogged about facets before, but I just thought that I’d mention them again, as they came in quite handy...
2011-04-24
515 reads
G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...
2011-04-22
733 reads
Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...
2011-04-13
2,646 reads
G’day,
I’ve been asked a few times lately to explain what a heap is.
I’m quite happy to do this, but I...
2011-04-10
2,395 reads
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,030 reads
G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...
2011-04-03
622 reads
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
566 reads
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
As AI continues to evolve, many of us are looking for ways to leverage...
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
Comments posted to this topic are about the item Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers