sql-server

How to set bufferpool to 8K on SQL server 2005 database

How to set bufferpool to 8K on SQL server 2005 database ...

Check the date with Linq-to-SQL

I have the following problem: in a database table are Sales recorded. One of the field is the SaleDate which is a SQL Server Date type. The Website now allows to search in this field. And it allows to search only for the year. Let's assume there is one record with the date 2008/11/01. If I search for "2008" the entry is returned, which ...

Condition in Where Clause - SQL Server

How can I filter columns in where condition based on valued passed. Ex: declare @number nvarchar(200) set @number = '2ddafa3' Here @number could be int or uniqueIdentifer so in where clause how can i achieve something as below. select * from IntegrationIDTransactions where case ISNUMERIC(@number) When 1 Then [TransactioniD...

SQL Server 2005 Job Schedule

Can we schedule a Stored Procedure to run every 3 seconds in SQL server 2005 ? I could not find a way to schedule it so currently i am calling from front-end. The schedular interface allow minimum 1 minute of scheduling. ...

How to avoid dupicate request?

If i click a link ia m calling a servlet. Is there any possibility to track the duplicate request thru filter or something so that i can avoid hitting the servlet? ...

Remote Database Managemnet

I am looking for a .Net Web Application to manage a Sql Server 2005 database, i am thinking something along the lines of phpmyadmin. Note : My current hosting provider does not provide any management interface or allow direct connections. ...

Reducing Size Of SQL Backup?

I am using SQL Express 2005 and do a backup of all DB's every night. I noticed one DB getting larger and larger. I looked at the DB and cannot see why its getting so big! I was wondering if its something to do with the log file? Looking for tips on how to find out why its getting so big when its not got that much data in it - Also how t...

SQL Server Bug?

Hi There, I am writing a function to process some CSV data. This is what I have written so far... CREATE FUNCTION dbo.FGetCommaSeperatedValues(@csv as text) RETURNS @tblIds TABLE(id int,csvlength int) AS BEGIN DECLARE @csvlength AS int --SET @csvlength = datalength(@csv); SET @csvlength = 7685 DECLARE @currentIndex AS...

Stored proc and program are still running even though browser is closed???

i have a .NET page that will perform calculation by calling a stored proc in SQL Server whn user click on a button. Normally, the calculation takes approxiamately 2 mins to complete and upon completion it will update a field in the table. Now i have a issue that, when user accidentally close the browser, the stored proc will still be run...

adding lock option to Create Table statement in Sql Server 2005

I am busy creating tables in Sql Server from a Sybase database. In the Sybase database when the tables are created an option 'lock allpages' was used, how can I replicate this when creating the tables in Sql Server 2005. ...

SQL-Server access with WCF: Timeout

I have a server with a SQL2008 Database and IIS7. I created a WCF service, that access the SQL-Server and returns the resultset in form of a List<T>. My problem is, that I get timeouts when accessing the service from my client, although the query should not take too long (about 1 sec in SQL-manager) it fetches 17.256 lines. When I con...

SQL server timeout issue

Possible Duplicate: SQL server timeout Hi, my application is developed on classic asp, but also uses asp.net as I am migrating the application on .Net. Its using SQL server as database and hosted on Windows server 2003. Now the problem is that the application continue to work perfectly fine for a long time but then after some t...

How long does it take to create an identity column?

I have a table that have 40million records. What's best (faster)? Create a column directly in that table or create another table with identity column and insert data from first? If I create an identity column in the table that have 40million records, is it possible estimate how long does it take to create it? ...

How can I check if a View exists in a Database?

Hi, I have some SQL code that needs to be executed if a certain View exists in a database. How would I go about checking if the View exists? EDIT: The DBMS being used is Microsoft SQL Server ...

Adding percentages to multiple counts in one SQL SELECT Query

I have a SELECT statement similar to the one below which returns several counts in one query. SELECT invalidCount = (SELECT COUNT(*) FROM <...a...> WHERE <...b...>), unknownCount = (SELECT COUNT(*) FROM <...c...> WHERE <...d...>), totalCount = (SELECT COUNT(*) FROM <...e...> WHERE <...f...>) This works fine but I wanted to...

Checking If Database In Restoring State

I'm running a T-SQL script that drops a database and then restores it. The script runs against a SQL Server 2008 database. Sometimes there is a problem with the backup file and the database gets stuck in the restoring state. IF EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name = 'dbname') BEGIN ALTER DATABASE [dbname] ...

Preventing DateTime changes.

Hi, in Silverligh + RIA app, I am retriving date from mssql08 server, when it reaches client side it is automatically converted into UTC time. How can I prevent RIA or SL from doing that? Regards MK ...

How to edit a SQL Server XML data field with asp.net Dynamic Data

I have a site based around asp.net 3.5's Dynamic Data feature. Everything's working great, but I would like to add a tagging feature via a column with an XML data type. I've made the column and added an appropriate schema, but it is showing up as read-only and the scaffold will not display or modify the field. So, I have a few question...

Recovering deleted objects from sql server

Does anyone know of any tools that can help in recovering dropped tables and stored procedures ? There was no backup taken and this DB was accidentally synced up with another DB and the new tables created in this DB were dropped. thanks ...

Importing excel spreadsheet in sql server 2000

I have a question regarding importing( Via the import/export wizard) an excel spreadsheet into sql server 2000. Everything seems to run fine, no errors etc, but when I select the data from my table, I've noticed that it skiped the first row. I thought maybe there was a "1st row is Data headers" flag , but I can't seem to find anything ...