Cluster environment with SQL Server 2008
Does SQL Server 2008 web edition support cluster environment? ...
sql-server-2008
Can you create a user-defined INFORMATION_SCHEMA view in SQL Server 2008?
Back in SQL Server 2000, you could create your own custom information_schema views using an undocumented stored procedure called sp_ms_upd_sysobj_category. The trick seems to have been introduced to the world by Ken Henderson in his book, The Guru's guide to SQL server stored procedures, XML, and HTML. I used it to create two handy vie...
How should I migrate this data into these Sql Server tables?
Hi folks, I wish to migrate some data from a single table into these new THREE tables. Here's my destination schema: Notice that I need to insert into the first Location table .. grab the SCOPE_IDENTITY() .. then insert the rows into the Boundary and Country tables. The SCOPE_IDENTITY() is killing me :( meaning, I can only see a w...
column to row in sql server ?
Table: CREATE TABLE Table1 ( col1 INT, col2 nvarchar(10), col3 INT, col4 INT ); INSERT INTO Table1 (col1, col2, col3, col4) VALUES (1, 'welcome', 3, 4); My table have different data type , col2 is nvarchar h can i do this ... result: col value --------------- col1 1 col2 welcome col3 3 col4 4 ...
Is it possible to pass table-valued parameters to stored procedure using NHibernate?
If possible give short example or link to example, thanks. ...
about full text query in SQL
Hello everyone, I have a nvarchar column which contains English and Japanese text. I want to make full text search on this column. When configure full text search, we need to specify language option for word breaker (e.g. using English work breaker or using Japanese word breaker). I am wondering in this case, what language should I assi...
Exec an SQL-Server 2008 stored-procedure from Access, passing a TABLE variable
I need to pass a table from Access to SQL-server and execute a stored-procedure. I'm using pass-through queries in Access to do this. My pass-through query: DECLARE @MyVar TABLE { .....<variables> } INSERT INTO @MyVar SELECT * FROM [MyTable] EXEC sproc_test @Myvar My stored-procedure: ALTER PROCEDURE [dbo].[sproc_test] @M...
SQL Server alias for a cluster?
Hi, I'm looking for a bit of advice setting up a SQL cluster to be accessed via an alias. At present, say my cluster is called 'SQLCLUSTER' and I want to set up an alias to redirect to it. Ideally, I'd like any attempt to connect to '(local)' on either of the machines in the cluster to redirect to 'SQLCLUSTER'. I'm using SQL server 200...
multiple access to sql server database, one table
I have multiple apps running which access a sql server database. I had initially a table set aside for each app but now I was told to put everything into one table and have all apps access the database. I just want to make sure that just changing my connection string for all apps will suffice and that I do not have to make any other chan...
Is it possible to do a 'dirty update' ?
I have a SPROC that runs every hour. This SPROC calculates the popularity of a users artwork and updates the popularity column on the main artwork table. This is the same table where users are writing to it each time they upload a new artwork. The problem is, this sproc keeps getting deadlocked with another transaction. Considering I ...
Easiest Way To Diff Two Table Schemas In SQL Server 2008?
I have to do checks between a development and release database and do this manually, which is both slow and not 100% reliable (I only visually inspect the tables). Is there a quick and easy way to compare table schemas automatically? Maybe even a feature that does this built right into SQL server? Edit: I'm comparing structure only, t...
problem in writing a sql query
Hi all, Getting a problem in writing an sql query. two tables: 1st: created patient table 2nd: already created doc table patientid patientname docid workstatus docid docname 1 aaa 2 10 1 ggg 2 bbb 2 20 ...
Insert Statement / Stored Proc dead locks
I have an insert statement that was deadlocking using linq. So I placed it in a stored proc incase the surrounding statements were affecting it. Now the Stored Proc is dead locked. Something about the insert statement is locking itself according to the Server Profiler. It claims that two of those insert statements were waiting for the ...
SQL, parse string like "12M" to 12 * 30 as an int
Hi, In a stored procedure in SQL Server 2008, I need to parse strings like "12M" and return 12 * 30 days as an int. So, I am basically parsing and calculating the number of days the string represents. I am not sure how this can be done. I am thinking to do a while loop over each character in the string. Any suggestion? Edit (not aut...
SQL Server 2008 Web edition
Dear Team, My company is planning to migrate it's intranet/internet based ERP to the latest form of MS SQL Database available. Presently we are using SQL Server 2000 Professional. And we are planning to shift to SQL Server 2008 Web edition. Please tell me whether this is the right step and whether it is feasible or not. Thank you in ...
Null paramters in store procedure.
What is the best method of handling null parameters in store procedure ? I have a store procedure with 3 input parameter any one of them parameter can be null so how to handle those parameter. SP_GetDetails input parameter (varchar p1,varchar p2,int p3, datetime p4, datetime p5) In sp there are different query based on input paramete...
How can I copy a row into same table with SQL Server 2008
A) My way so far: sqlCommand.CommandText = "INSERT Table1 ([column1],[column2],[column3])" + " SELECT [column1],[column2],[column3]" + " FROM Table1 WHERE Id =" + param + ";select scope_identity() as id"; B) I wish to do something like this: INSERT INTO "table1" (* (without the ID-column)) SELECT (...
SQL Server Transaction logs full, how to empty and delete them
My transaction log file is full, i have 5 log files , 2 in D: drive & 3 in E: drive. all the log file is full, each log file is 10GB in size. I need to delete all 5 transaction log file and need to have one fresh truncation log file i have tried method, 1. converted from Full to simple and shrik files (but not great effect , it does n...
Access queries running slow
I have an application with the front end in Access 2007 (Access 2000 file) with the backend on SQL Server 2008. The application has been running for two years now and I have noticed that on some PCs the queries are taking forever to run while on others it runs quite fast. Each PC has its own file of Access, so they don't share the file. ...
Selecting nvarchar 'like' in a left join - inner join combination
I currently have a query that returns results based on a dynamic set of conditions DataTable Items: ID Title 1 Some title 2 Some other title ..etc.. . DataTable Tags: ID Tag 1 'a1c' 1 'a1d' 2 'a2c' ..etc.. My current search Query: select * from dbo.Items i LEFT JOIN dbo.tags t on i.ID...