Here at Database Weekly, we scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week. Here, we have an assortment of the latest articles from selected sources.
At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.
I am using the `[sys].[dm_db_index_usage_stats]` view to find unused indexes. I am looking for all of the following fields to be equal to `0`:
I have historic tables in my database created with dates attached to the name of the table.
i have two tables called t and t1 . Problem : if no data is available in #t1 then i need to insert and if data is avialable then i need to update . suppose ...
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey ...
During a transaction, data is written to the log cache so that it's ready to be written to the log file on commit, or can be rolled back if necessary. ...
With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file (starting from Excel 2013) perhaps there ...
Today I presented a fun session for the SQL PASS Performance Virtual Chapter’s “Summer Performance Palooza 2014” entitled “Infrastructure ...
I note question [http://ask.sqlservercentral.com/questions/113673/how-to-use-between-and-operator-for-negative-value.html] has not got any ...
I have Product It have product information over 10k Records.
We have Created Full Text INDEX and using CONTAINSTABLE(),FREETEXTTABLE(),FREETEXT()
How do you get the boss to pay for training? In my experience you have to:
Ask. The boss isn't sitting around thinking of ways to make your life better ...
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought ...
Please help me on this.
I have subscribed a report with Window File Share to save the file in specified path. but Customer want to saved ...
Is there a way to return a list of distinct table names used in all procedures for a specific database? Some procedures references tables on the ...
I have a new sql instance which is not yet live. Someone has removed the model database by accident. I was able to start the instance using both trace ...
We had one table, one of column contains negative and positive values, how can we get required data by using BETWEEN operator?
Example we are using below ...
What is the scope of SQl Server, since now no sql DBs are emerging high in markets?
Is it better to stick with SQl or go ahead and learn NOSQL DBS. which ...
I have a table of Parent/Child relationships. Some parents have exactly the same group of children. I need to find which ones. For example I ...
We have file coming from FTP site and this file is zipped. Inside the zip file there is .bak file holding backup files . The name of the backups are constants ...
I have 3 tables
CategorySerno | CategoryName
Should decisions be made on instinct or with data?
SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL ...
Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save ...
Red Gate's running a half-day training workshop at their UK head office in Cambridge on Aug 8. It'll show you how to link your database source control ...
1. Assume that the fields "ID" and "Manager" exist as Integers for each entry in the "Persons" table. Write a SQL Function that accepts an "ID" and returns ...
Just the chart today. We're considerably ahead of previous year registrations for the same number of weeks out. I'm looking at that number every day now!
I have a table tablex that contains rows of data like field1, field2, field3.
If I use this: select field1, field2, field3 from tablex
I was working on a small piece of code the other day that was calculating the seconds for an event. I had a function that returned me the seconds as an ...
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:
Oh please! Couldn’t we be ...
Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check? Recently ...
This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there ...
Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels ...
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download ...
At least it's not Sage.
There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. ...
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting ...
A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data ...
We're at 180 registered so far and we haven't published the schedule yet! So far so good. We're on track to have the schedule live at 60 days out, maybe ...