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.

Latest Articles


SQLServerCentral - Questions
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 ...
by FranklinSenthil
00:08 25-Jul-2014
SQLServerCentral - Editorials
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
23:00 24-Jul-2014
SQLServerCentral - Main Articles
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
23:00 24-Jul-2014
SQLServerCentral - Main Articles
Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey ...
23:00 24-Jul-2014
SQLServerCentral - Main Articles
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. ...
23:00 24-Jul-2014
SQLServerCentral - Blogs
Today I presented a fun session for the SQL PASS Performance Virtual Chapter’s “Summer Performance Palooza 2014” entitled “Infrastructure ...
17:11 24-Jul-2014
SQLServerCentral - Questions
Hello, I note question [http://ask.sqlservercentral.com/questions/113673/how-to-use-between-and-operator-for-negative-value.html][1] has not got any ...
by Dave_Green
16:40 24-Jul-2014
SQLServerCentral - Questions
Hi, I have Product It have product information over 10k Records. We have Created Full Text INDEX and using CONTAINSTABLE(),FREETEXTTABLE(),FREETEXT() This ...
by sqlqa
16:07 24-Jul-2014
SQLServerCentral - Blogs
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 ...
15:27 24-Jul-2014
SQLServerCentral - Blogs
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 ...
14:47 24-Jul-2014
SQLServerCentral - Questions
Hello All, 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 ...
by Binod
14:17 24-Jul-2014
SQLServerCentral - Questions
Hi all 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 ...
by ruancra
13:43 24-Jul-2014
SQLServerCentral - Questions
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 ...
by sqlLearner 1
12:30 24-Jul-2014
SQLServerCentral - Questions
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 ...
by prasad.nyalapatla
10:59 24-Jul-2014
SQLServerCentral - Questions
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 ...
by madhanmohan
09:14 24-Jul-2014
SQLServerCentral - Questions
Hi all, 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 ...
by mjharper
08:23 24-Jul-2014
SQLServerCentral - Questions
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 ...
by fantumahi2
03:24 24-Jul-2014
SQLServerCentral - Questions
I have 3 tables >Category CategorySerno | CategoryName 1 One 2 Two 3 Three ...
by fashraf
00:06 24-Jul-2014
SQLServerCentral - Editorials
Should decisions be made on instinct or with data?
23:00 23-Jul-2014
SQLServerCentral - Main Articles
SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL ...
23:00 23-Jul-2014
SQLServerCentral - Main Articles
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 ...
23:00 23-Jul-2014
SQLServerCentral - Main Articles
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 ...
23:00 23-Jul-2014
SQLServerCentral - Questions
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 ...
by mbgreen2
21:38 23-Jul-2014
SQLServerCentral - Blogs
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!   ...
19:36 23-Jul-2014
SQLServerCentral - Questions
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 get: field1 ...
by donw5288
17:28 23-Jul-2014
SQLServerCentral - Questions
I'm trying to look at currently running queries by using the sys.dm_exec_requests DMV but I don't have the permission. I also tried to look at the query ...
by liton
16:58 23-Jul-2014
SQLServerCentral - Questions
the error is SQLSTATE: 08001 code: 53 message: [Microsoft][SQL Server Native Client 11.0]Named Pipes ...
by pbalendra
15:38 23-Jul-2014
SQLServerCentral - Blogs
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 ...
14:42 23-Jul-2014
SQLServerCentral - Blogs
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 ...
13:09 23-Jul-2014
SQLServerCentral - Blogs
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 ...
12:00 23-Jul-2014
SQLServerCentral - Blogs
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 ...
11:00 23-Jul-2014
SQLServerCentral - Blogs
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 ...
08:33 23-Jul-2014
SQLServerCentral - Blogs
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download ...
08:30 23-Jul-2014
SQLServerCentral - Editorials
At least it's not Sage.
23:00 22-Jul-2014
SQLServerCentral - Main Articles
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. ...
23:00 22-Jul-2014
SQLServerCentral - Main Articles
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting ...
23:00 22-Jul-2014
SQLServerCentral - Main Articles
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 ...
23:00 22-Jul-2014
SQLServerCentral - Blogs
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 ...
19:58 22-Jul-2014
SQLServerCentral - Blogs
When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL).  If you decide T-SQL is the way to go and you just ...
14:00 22-Jul-2014