SQL Server Tag Directory

SQL Server Tags - SQL to SQL

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,   >>  VIEW SQL SERVER TAGS - SQL to SQL

Featured SQL Server Questions

Disk Partitioning w/SQL Server 2000/2005/2008
I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am referring to...

Answer Question   |  April 3, 2014  3:51 PM
Partitioning, SQL Server 2000, SQL Server 2005, SQL Server 2008
asked by:
5 pts.

SQL Server 2008 database backup terminating abnormally
I’m running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log adventureworks to disk='g:radvent6.trn' After the backup log command executes, it shows the error as: The statement BACKUP LOG is not allowed while the...

Answer Question   |  April 3, 2014  12:38 PM
Backup, Database Backup, SQL Server 2008
asked by:
15 pts.

How many users can access the file stored on SQL Server 2008?
After we store any file on our SQL Server 2008, how many clients will able to access that particular file from the server at a time?

Answer Question   |  March 27, 2014  11:45 AM
AS/400, SQL Server 2008
asked by:
5 pts.

Behaviour of Service Broker during clustered SQL Server failover
Hi, I have 3 instances of SQL Server 2005 hosted on a 3-node cluster, using Polyserve clustering.  Each instance is nominally hosted on its own node in the cluster. I have configured Service Broker to route messages from INST-A (on NODE-1) to INST-C (on NODE-3), using TCP and a NetBIOS name.  This NetBIOS name obviously...

Answer Question   |  March 14, 2014  2:26 AM
SQL Server clustering, SQL Server Service Broker
asked by:
5 pts.

How can I restore a database from .mdf file?
How can I restore a database from .mdf file? I only have .mdf backup file.

Answer Question   |  February 12, 2014  12:01 AM
SQL Server backup, SQL Server database restore
2,585 pts.

Setting a username and password in SQL Server
How do I set the username and password in SQL Server to allow connection to the database?

Answer Question   |  January 29, 2014  7:37 PM
SQL Server, SQL Server administration, SQL Server authentication, SQL Server connectivity
2,585 pts.

Need SQL 2012 alert to run when job step fails
I have a mutli step SQL Server job that when one of the steps fail an alert needs to be sent out, however the job can’t fail on this step it needs to continue. I have tried a trigger on sysjobshistory but that has gotten kind of ugly. So for example: 3 step job step...

Answer Question   |  January 28, 2014  3:23 PM
SQL Server 2012
asked by:
95 pts.

SQL Server on SAN
I a two server set up. Server one for my application and server two a SAN for my SQL Server.  Should I install the SQL server on the SAN?  I have read about 10 articles and some state to install the SQL Server on the app server while others say on the SAN and yet...

Answer Question   |  January 7, 2014  5:35 AM
SAN, SAN Configuration, SQL Server, SQL Server configuration
asked by:
5 pts.

Establishing a connection from an IBM DB2 database
I’ve been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have: Server Name Data Library Username/Password I’ve used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have gone...

Answer Question   |  December 24, 2013  4:50 PM
IBM DB2, Microsoft Excel, SQL Server 2008
asked by:
54,755 pts.

Apps built on SQL Server 2005 running in 2008?
Will applications built in SQL Server 2005 run in a SQL Server 2008 environment

Answer Question   |  December 18, 2013  3:15 PM
Applications, SQL Server 2005, SQL Server 2008
asked by:
5 pts.

Clustered index in SQL Server 2012
A clustered index is created automatically in SQLserver 2012 while creating a table with primary key. The index is created on the primary key field. My queries which are not using the primary key for search are costing 100% on clustered index scan. Should I create covered index for each and every query or what...

Answer Question   |  November 26, 2013  9:33 AM
Clustered Index, SQL Server 2012, SQL Server Clustered Index
asked by:
5 pts.

Should we use Hyper-V snapshot for backup on SQL Server 2008
So we have SQL Server 2008 in Hyper-V as a supported configuration. It’s been performing well since we’re using fixed or pass-through disks (which has increased our processor/memory settings). My big question is can we use snapshots as a reliable backup mechanism? Should we use the tried and trusted maintenance plan to do our backups?

Answer Question   |  November 6, 2013  6:13 PM
Backup, Hyper-V, SQL Server 2008
asked by:
54,755 pts.

Trying to get rid of “divide by zero” error message using SQL Server 2008
In SQL Server 2008, I keep receiving this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. Now, this is more of a general question but what is the best way to write SQL code so this message will never appear again.

Answer Question   |  October 31, 2013  1:45 PM
SQL Server 2008, SQL Server error messages
asked by:
54,755 pts.

Free Chapter – Hardening a SQL Server implementation
Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration. Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert...

Answer Question   |  October 29, 2013  3:24 PM
Database security, Free Chapters, Hilary Cotter, Ross Mistry, Sams Publishing, SQL Server, SQL Server 2008, SQL Server security
asked by:
6,875 pts.

Advantages and disadvantages of clustered indexes
What are the advantages and disadvantages of clustered indexes?

Answer Question   |  October 28, 2013  4:41 PM
Clustered Index, SQL Server Clustered Index
2,585 pts.

High LATCH_EX wait
What is LATCH_EX wait? Our LATCH_EX wait is very high. What do I need to look at to fix this?

Answer Question   |  October 28, 2013  6:19 PM
SQL Server, SQL Server 2008, SQL Server Enterprise Edition, SQL Server performance
asked by:
585 pts.

Row by Row Stored Procedure in SQL Server 2008 R2
Hi all, Hopefully someone will be able to help me here – I’m nearly there but can’t get it right, I’m trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have...

Answer Question   |  October 25, 2013  1:36 PM
SQL, SQL Server 2008, SQL Server 2008 R2, SQL stored procedures, Stored Procedures
asked by:
65 pts.

SQL Server 2005 Express SP3 Memory Usage
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I...

Answer Question   |  October 23, 2013  12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
asked by:
5 pts.

SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB...

Answer Question   |  October 23, 2013  9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
asked by:
60 pts.

Performance benchmarks for SQL Server 2008 R2
Have performance benchmarks for SQL Server 2008 R2 been published somewhere?

Answer Question   |  October 23, 2013  8:25 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
asked by:
54,755 pts.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: