I’m using SQL Server 2008, may be will go to 2012 in near future and I have a question.
I have a table with 10 filleds, that will go to some millions records. In that table I should add a nvarchar(50) which will be used only for some customers, for others this Keyword nvarchar(50) filed will be empty.
So my question is – for the customers that will NOT use at all this Keyword field, this will increase the size of DB or not? What exactly type I should use and at all, what should I do to minimize the recourses used for the customer with Keywords = null ??? I prefer not to make different logic …
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.