Search Results

Search found 855 results on 35 pages for 'mssql'.

Page 8/35 | < Previous Page | 4 5 6 7 8 9 10 11 12 13 14 15 | Next Page >

Best optimizing for a large MSSQL table (100-200 Mil records)

- by RPS

What are the best options/recommendations and optimizations that can be performed when working with a large MS SQL 2005 table that contains anywhere from 100-200 Million records?

Read the article
MSSQL Efficiently dropping a group of rows with millions and millions of rows

- by Net Citizen

I recently asked this question: http://stackoverflow.com/questions/2519183/ms-sql-share-identity-seed-amongst-tables (Many people wondered why) I have the following layout of a table: Table: Stars starId bigint categoryId bigint starname varchar(200) But my problem is that I have millions and millions of rows. So when I want to delete stars…

Read the article
Connecting to mssql in Php - Extension Err

- by John Doe

<html> <head> <title>Connecting </title> </head> <body> <?php $host = "*.*.*.*"; $username = "xxx"; $password = "xxx"; $db_name = "xxx"; $db = mssql_connect($host, $username,$password) or die("Couldnt Connect"); $selected = mssql_select_db($db_name, $db) or…

Read the article
PERSISTENCE LOB WITH JPA

- by rfders

Hi, Folks. I have this problem using JBOSS, EJB3 and MSSQL Express . i'm trying to persist an entity with an Blob attribute which was converted into a byte[], apparently it create the entity perfectly, no error was logged at jboss's console. but when i check into database the column is null. i already checked the Object to byte[] method and…

Read the article
MsSQL 2005 query performance

- by Max

I have the following query: select ............. from //one table and about 20 left joins// where ( ( this_.driverName like 'blah*' or this_.renterName like 'blah*' ) or exists ( select this0__.id as y0_ from ThirdParty…

Read the article
.NET and Closing MSSQL connections

- by user307076

I am having a hard time figuring out why the following constructor will not close connnections. When I view the active connections. Here is the code that I have. Public Sub New(ByVal UserID As Integer) Dim oConn As New SqlConnection(ConfigurationManager.ConnectionStrings("connStr").ToString()) Dim cmd As New…

Read the article
Need suggestions on how to extract data from .docx/.doc file then into mssql

- by DarkPP

I'm suppose to develop an automated application for my project, it will load past-year examination/exercises paper (word file), detect the sections accordingly, extract the questions and images in that section, and then store the questions and images into the database. (Preview of the question paper is at the bottom of this…

Read the article
Recommendations for supporting both Oracle and MSSQL in the same ASP.NET app with NHibernate

- by Hugo Zapata

Our client wants to support both SQLServer and Oracle in the next project. Our experience comes from .NET/SQL Server platform. We will hire an Oracle developer, but our concern is with the DataAccess code. Will NHibernate make the DB Engine transparent for us? I don't think so, but i would like to hear from developers who…

Read the article
how to get LIKE clause to work in asp.net and mssql

- by anoob836

Hi, I am doing a really simple query in asp.net but after I inserted the LIKE clause it stops working. Example: String sql = " SELECT * FROM Products WHERE ID = @MYID AND Name LIKE '%@MYNAME%' "; SqlCommand command = new SqlCommand(sql, cn); If I removed the LIKE it works. Hence I am thinking its to do with the ''…

Read the article
MSSQL 2008 FTS CONTAINSTABLE Not Returning More Than Five Rows

- by Elijah Glover

I have a single table called "Indexes", it contains one nvarchar and three ntext columns (all Full Text Indexes). Index is up to date. CONTAINSTABLE(Indexes, *), 'test', 5) //5 results No matter what I change the above keyword too, it only returns the first 3-5 results. It should roughly return 90-120 results, for…

Read the article
Transform Search String into FullText Compatible Search String?

- by Alex

I'm working with the fulltext search engine of MSSQL 2008 which expects a search string like this: ("keyword1" AND "keyword2*" OR "keyword3") My users are entering things like this: engine 2009 "san francisco" hotel december xyz stuff* "in miami" 1234 something or "something else" I'm trying to transform…

Read the article
What does MSSQL execution plan show?

- by tim

There is the following code: declare @XmlData xml = '<Locations> <Location rid="1"/> </Locations>' declare @LocationList table (RID char(32)); insert into @LocationList(RID) select Location.RID.value('@rid','CHAR(32)') from @XmlData.nodes('/Locations/Location') Location(RID) insert into…

Read the article
"Priming" a whole database in MSSQL for first-hit speed

- by David Spillett

For a particular apps I have a set of queries that I run each time the database has been restarted for any reason (server reboot usually). These "prime" SQL Server's page cache with the common core working set of the data so that the app is not unusually slow the first time a user logs in afterwards. One…

Read the article
Getting an odd error, MSSQL Query using `WITH` clause

- by Aren B

The following query: WITH CteProductLookup(ProductId, oid) AS ( SELECT p.ProductID, p.oid FROM [dbo].[ME_CatalogProducts] p ) SELECT rel.Name as RelationshipName, pl.ProductId as FromProductId, pl2.ProductId as ToProductId FROM ( …

Read the article
ASP.NET MSSQL Select top N values but skip M results

- by Mikey

Im working on an ASP.Net project to display information on a website from a database. I want to select the top 10 items from a news table but skip the first Item and I'm having some problem with it. <asp:SqlDataSource ID="SqlDataSource1" runat="server"…

Read the article
MsSql Server high Resource Waits and Head Blocker

- by MartinHN

Hi I have a MS SQL Server 2008 Standard installation running a database for a webshop. The current size of the database is 2.5 GB. Running on Windows 2008 Standard. Dual Intel Xeon X5355 @ 2.00 GHz. 4 GB RAM. When I open the Activity Monitor, I see that I have a Wait Time…

Read the article
MSSQL Search Proper Names Full Text Index vs LIKE + SOUNDEX

- by Matthew Talbert

I have a database of names of people that has (currently) 35 million rows. I need to know what is the best method for quickly searching these names. The current system (not designed by me), simply has the first and last name columns indexed and uses "LIKE" queries with the…

Read the article
How do I Duplicate a MSSQL Symmetric Key

- by rlb.usa

We have a server with a database that has a symmetric key (Database - Security - Symmetric Key). We have a backup duplicate databases that we are using as a test databases, but we don't have this key in there. How can I duplicate this symmetric key and put it in the…

Read the article
MSSQL choosing row (from group) with max value

- by sriehl

I have a large database and am putting together a report of the data. I have aggregated and summed the data from many tables to get two tables that look like the following. id | code | value id | code | value 13 | AA | 0.5 13 | AC | 2.0 13 | …

Read the article
MSSQL, varchar data to nvarchar data

- by Øyvind

I've got a database with collation Danish_Norwegian_CS_AS and lots of varchar columns. I'd like to convert all this data to unicode, but haven't found a way to convert this data yet. If I've understood correctly, the encoding used is UCS-2 little endian. For…

Read the article
Storing JSON in an msSQL database?

- by JKirchartz

I'm developing a form generator, and wondering if it would be bad mojo to store JSON in an SQL database? I want to keep my database & tables simple, so I was going to have `pKey, formTitle, formJSON` on a table, and then store …

Read the article
How can I Duplicate a MSSQL Symmetric Key?

- by rlb.usa

We have a server with a database that has a symmetric key (Database - Security - Symmetric Key). We have a backup duplicate databases that we are using as a test databases, but we don't have this key in there. How can I duplicate this…

Read the article
SCD2 + Merge Statement + MSSQL

- by Nev_Rahd

I am trying work out with MERGE statment to Insert / Update Dimension Table of Type SCD2 My source is a Table var to Merge with Dimension table. My Merget statement is throwing an error as: The target table…

Read the article
Rename column in mssql

- by zurna

I tried the following code. Altough I dont get any errors, it did not do it. SELECT * FROM Categories EXEC sp_rename 'Active', CategoriesActive

Read the article
Export products and variants from MSSQL

- by mickyjtwin

I have a SQL DB that has a table of products, and another table which contains a list of the sku variants of each product if it has one. I want to export all the products and their SKU's into excel. At the…

Read the article

< Previous Page | 4 5 6 7 8 9 10 11 12 13 14 15 | Next Page >