(Axel Achten) For some time I wanted to document the possibilities of the SQL Server Database Project and how developers and DBA’s can benefit from it.
Tag: sql server
Performance Tuning Re-indexing and Update Statistics – A Case Study
(satnam singh) Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in appli
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1
(Pinal Dave) Index never stops amazing me, there are so much to learn about Index that I never feel that there is enough knowledge out about this subject. If you are interested you can watch my Indexing Course on Pluralsight for further learning on this subject.
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
(Bob Dorr) The scenario: •Table has a NTEXT column that the customer wanted converted to NVARCHAR(MAX) •Data has both small and large storage for different rows •Issued ALTER TABLE … ADD COLUMN …NVarCharColumn… NVARCHAR(MAX) •Issued update MyTable set NVarCharColumn = •Issued AL
What questions to ask when planning a SQL Server backup strategy
(Kat Meadows) Every database holds different business data and has its own recovery needs. Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking yourself and the business
SQL Server Temp Table vs Table Variable Performance Testing
(Ben Snaidero) If you’ve been a DBA for any amount of time I’m sure you’ve been asked the question: Which is better to use, a temp table or a table variable? There are technical reasons why to use one over the other, but being that I am usually just interested in performance I am more concerned with
SQL SERVER – Fix: Error: The conversion returned status value 2 and status text ‘The value could not be converted because of a potential loss of data.’. (SQL Server Import and Export Wizard)
(Pinal Dave) Here is the question received from user – the email was long and had multiple request from reader to resolve this error.
Adventures in SSRS
(Allen Kinsel) Came across a strange permission issue today that I thought I’d blog about since it is apparently somewhat common judging by the number of unanswered forum posts about it.
SQL Server – Login Failed, cannot open user default database
(Vishal Harishbhai Gajjar) Each login in SQL Server has a default database associated with it. When you login to SQL Server context is set to default database for login. This is set when login is created and it can be changed by using ALTER LOGIN command.
T-SQL script to add new schedule to existing job
(John Pertell) Like a lot of fellow SQL Server DBA’s I have a number of production servers to manage. One of the tasks I have to perform every year is to create a new set of one-time schedules for an existing job. The date of the schedule varies from month to month due to different business logic.