- Subscribe to this page:
- RSS
- Email Alert
databases
(19838 results)-
Articles
Using NOLOCK and READPAST table hints in SQL Server
May 21, 2007 10:12pm PDT
Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server.
23 Latest comment by hamish.holder@...
-
Blog Post
10 things you should know about NoSQL databases
August 26, 2010 8:26am PDT
The relational database model has prevailed for decades, but a new type of database -- known as NoSQL -- is gaining attention in the enterprise. Here's an overview of its pros and cons.
56 Latest comment by Tony Hopkinson
-
Blog Post
SQL Server database developer interview questions and answers
September 28, 2012 5:41pm PDT
Development hiring managers and potential interviewees may find these open-ended SQL Server proficiency interview Q&As useful.
8 Latest comment by Tony Hopkinson
-
Blog Post
Help! My SQL Server Log File is too big!!!
September 22, 2008 1:26pm PDT
Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth...
9 Latest comment by mike_Chel
-
Articles
Oracle Tip: How to use default values with database columns
June 18, 2004 5:27pm PDT
Using default values on database columns helps to insulate database design issues from application code. Find out how to change a column's default value at a later date using a single command.
4 Latest comment by gurujothi37@...
-
-
Blog Post
How Do I... Restore a SQL Server database to a new server?
June 20, 2007 10:24am PDT
This blog entry is also available as a TechRepublic gallery and as a TechRepublic download. As a DBA, I have been in many situations where I had to move databases to a new server due to old...
26 Latest comment by Tony Hopkinson
-
Articles
10 tips for using wildcard characters in Microsoft Access criteria expressions
January 30, 2007 8:00am PST
Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard...
7 Latest comment by kevinowpb
-
Blog Post
Comparing cursor vs. WHILE loop performance in SQL Server 2008
November 11, 2009 7:03am PST
Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.
5 Latest comment by Tony Hopkinson
-
Blog Post
Passing table valued parameters in SQL Server 2008
August 27, 2007 12:47pm PDT
SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer...
5 Latest comment by joshgeake
-
Blog Post
Fine-tune your Access queries to remove duplicate entries from your mailing lists
August 4, 2008 8:35pm PDT
If you query your Access database to generate a mailing list, but the list contains duplicate names and addresses, this helpful trick will save you some time. See how tweaking the query properties...
1
-
Blog Post
Changing the name of your SQL Server
September 22, 2007 9:13pm PDT
Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to...
3 Latest comment by blangston1
-
Blog Post
Selectively disable UAC for your trusted Vista applications
March 13, 2008 12:00am PDT
Do you want to selectively disable User Account Control (UAC) for specific programs that run from Vista's Start menu? You can -- Greg Shultz shows you step by step using the Application...
28 Latest comment by aart12
-
Articles
Relational databases: Defining relationships between database tables
April 30, 2003 7:00am PDT
Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established.
4 Latest comment by jrcondit@...
-
Blog Post
Configuring SQL Developer for MySQL
November 27, 2007 5:56pm PST
I rant against Oracle products a lot in this blog, but I have to admit I actually like a few of their products. One of them is SQL Developer. Strangely though, the feature I kind of like best is...
4 Latest comment by MariposaLibre
-
Blog Post
Run a parameter query within an Access form
October 3, 2008 12:00am PDT
When your users need to run a parameter query while they're working in a form, this custom button will save them some time.
8 Latest comment by Noor110
-
Articles
Displaying money values in currency format in SQL
July 25, 2005 8:51pm PDT
Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.
1
-
Blog Post
10 tips for smarter, more efficient Internet searching
April 27, 2011 7:36am PDT
These days, everyone is expected to be up to speed on Internet search techniques. But there are still a few tricks that some users -- and even savvy searchers -- may not be aware of.
8 Latest comment by PEML
-
Blog Post
10+ things I can never find in Access 2007/2010
August 3, 2010 2:25pm PDT
Even after working a while with Access 2007 or 2010, you may be disoriented if you're used to earlier versions. Susan Harkins offers some help in locating the tools you need.
18 Latest comment by james_dono@...
-
Blog Post
How do I use BCP in SQL Server?
March 28, 2008 6:08pm PDT
The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and...
6 Latest comment by Henry_007
-
Blog Post
Eight steps to restore an individual Exchange 2010 mailbox with System Center Data Protection Manager
January 30, 2012 6:00am PST
Exchange admins often have to restore an individual mailbox rather than an entire database. John Joyner shows you eight steps to do this using PowerShell commands and Microsoft System Center DPM.
8 Latest comment by John Joyner
