sql-server

creating a address database

I am re-creating a part of my company’s database because it does not meet future needs. Currently we have mainly a flat file and some disjoined tables that were never fully realized. My way of thinking is we have a table for each category except maybe the zips table, which may serve as a connect it all together table. Please refer to im...

Recommendations for single user access Database

I am writing a desktop utility application to manage a small set of data. This application will be used by a singular person so I'd like to keep the database as simple as possible. I am considering XML or SQL Server Compact 3.5 (SQL CE). I am leaning towards SQL CE because it will probably be easier/quicker to develop than XML. Are there...

sql server 2005 source control

I have connected the Team Foundation Server to my SQL Server 2005 Management Studio and added my Stored Proc's to the new project to TFS. All my SP's are checked in and everything works fine. But I have a question. I have my project that shows in Solution Explorer and I have the Object Explorer that shows all the Databases and SP's on th...

Update SQL with consecutive numbering

I want to update a table with consecutive numbering starting with 1. The update has a where clause so only results that meet the clause will be renumbered. Can I accomplish this efficiently without using a temp table? ...

Copy File Job creation

Hi Friends, I need to copy a backup file from a server to a share every day. Actually I need to create a job to do that every day. I have created a bat file to do it. The problem is that I don't know how to have it run in the job. Is there any other way to do that. Please, suggest. I would really appreciate it. Thanks ...

Using sqlsrv_connect on Platforms other than Windows

I've inherited some code that uses the sqlsrv_connect method to instantiate a connection to a SQL Server database. My personal development machine is an OS X box that I'm running apache an PHP on. I have an instance of SQL Server running in a virtual machine. When I attempt to connect to the database, I get the following error. Fatal...

SQL 2008 Encryption Scan

We recently upgraded a database server from SQL 2005 to SQL 2008 64 bit. CPU utilization is oftentimes running at 100% on all four processors now (this never happended on the SQL 2005 server). When I run sp_lock I see a number of processes waiting on a resource called [ENCRYPTION_SCAN]. I am not using any SQL 2008 encryption features. Do...

If you could only monitor 10 SQL Server 2005 counters, what would they be?

Yes, this is rather subjective, but I am doing research on that matter and am curious to see if others have come to the same conclusions that I have. So, I ask, if you could only monitor 10 SQL Server 2005 counters, what would they be? ...

What's the fastest way to load a text or ntext SQL Server column?

I do this as simple as possible, but sometimes the query takes 3+ second. I'm using a basic parameterized query like this: SELECT TextStuff FROM MyInfo WITH (NOLOCK) WHERE MyInfoID=@MyInfoID Is there a faster way to do this? Would performance improve if I converted the ntext column into an nvarchar(MAX) column? ...

SQL Replication Setup - Almost There

I'm trying to setup replication between two SQL Servers and I'm almost there but stuck on a permission error (it appears). The servers are connected via VPN. Publisher/Distributer = W2003 + SQL2005 (Domain Controller) Subscriber = W2008 + SQL2008 (Stand Along Server not on a domain) I have set it up to Pull rather than push only beca...

Checking rule violations before deleting a record

I would like to implement a "soft-delete" scheme for a number of entities in my SQL Server 2005 database. By this, I mean I would like to delete an row from a table if there are no referential integrity rule violations, otherwise I will set a flag on the record to signify it has been deleted. The table I wish to enforce this "soft-delete...

How can I update multiple columns with a Replace in SQL server?

How do I update different columns and rows across a table? I want to do something similiar to replace a string in SQL server I want to do this but the value exists in multiple columns of the same type. The values are foreign keys varchars to an employee table. Each column represents a task, so the same employee may be assigned to severa...

Stop Monitoring SQL Services for Registered Servers in SMSS

Question: Is it possible to stop SSMS from monitoring the service status of registered servers? Details: SSMS 2008 monitors the service status of every registered server. From what I have seen it seems to reach out to every registered server every minute or so to check it's status, in my case that is over 100 servers. This process has...

Limitations of SQL Server Express

Hi, My hosting provider (Rackspace) is offering a fully managed dedicated server with SQL Server Web verion () installed. My company handles web development, and has about 20+ clients using ASP.Net + SQL Server 2005. I am thinking of cutting down costs by installing the free SQL Server 2008 Express instead. I am aware of the 1GB RAM a...

How can I change database from SQL Server to Oracle with SubSonic?

I write code with SubSonic 2.1.1 and used MSSQL. The project must be run with Oracle now. I changed web.config, and it does not work. Can someone give me a sample which changes database only - changes web.config with subsonic and the rest doesn't change? Table name in MSSQL is "Name" but in Oracle is "NAME". Can subsonic generate "Name"...

how to fetch data from database?

how we can fetch the data from the database through Silver light? I want the basics only. because i am a fresher in silver light. ...

Storing the url in SQLSERVER 2005 using C# code(data sets)

I was trying to store the url on button click using the following code.There were no error but the required url is not sroeing in my column field (i used ntext data tpe for this).Please help me if there was some mistake in my code public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs ...

A good tool to populate database with dummy data?

is there a good freeware that generates fake data for SQL Server? It would be really great if the tool generate the data according to foreign key (other constraints). Its such a repetitive task I am sure there must be a good tool for this but somehow i cant seem to find it. ...

Is accessing rows with varbinary data via LINQ causing a timeout? How to fix?

I have a number of tables in SQL. One is Controls (a typical CRUD sort of object) and one is Attachments. Attachments references Controls via a FK (there can be many attachments). Attachments also includes, amongst other things, a name and a varbinary column with file data. Through linq, Control has an Attachments property. I have a Co...

SQL Server - Guid VS. Long

Hello! Up until now i've been using the C# "Guid = Guid.NewGuid();" method to generate a unique ID that can be stored as the ID field in some of my SQL Server database tables using Linq to SQL. I've been informed that for indexing reasons, using a GUID is a bad idea and that I should use an auto-incrementing Long instead. Will using a lo...