Search Results

Search found 31328 results on 1254 pages for 'sql join'.

Page 393/1254 | < Previous Page | 389 390 391 392 393 394 395 396 397 398 399 400  | Next Page >

• SPROC runs in Query Analyzer 2008 Enterprise but will not run inside a Job on SQL Agent

  - by jim-johnston

  I have a stored procedure that runs in Query Analyzer 2008 Enterprise but will not run inside a Job on SQL Agent. It just spins. I have checked permissions, ANSI NULL ON , etc. to no avail. Funny thing is I can wrap a SSIS package around it and then run it from a Agent Job and it works. Any ideas? Thanks in advance V/R Jim

  Read the article

• Configuring SQL for optimal performance... SSD or HDD?

  - by spoon16

  Does anyone know of any comparisons that show how SSDs compare to HDDs for performance in a SQL environment? I'm trying to understand what type of performance benefit might be gained by moving to SSD.

  Read the article

• How many times can I reinstall SQL Server 2008 using the same product key?

  - by twpc

  I have attempted to install SQL Server 2008 twice so far, but have gotten errors. Would like to try again. Is there a limited number of times that the same product key can be used before I have problems?

  Read the article

• How do I change the Web Service Account for SQL Server Reporting Services?

  - by anD666

  Hello, I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy

  Read the article

• Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment?

  - by Michael Rosario

  Hello world. Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment? From an IT professional position, why would I not allow Oracle XE and MSSQL2005 to run on the same server?

  Read the article

• How can a cached query take 2500 ms on a Sql Server 2008?

  - by Lieven Cardoen

  How is it possible that a cached query could take that long. With cache cleared it takes 25000 ms (I know that's just way too long but that's not the issue here). Once it is cached, it takes 2500 ms. What could be the problem here? If it's cached, I assume Sql Server gets it out of the RAM. So, again, 2500ms???

  Read the article

• Is there a rule to define a primary key on a sql-Server table for access with MS-Access?

  - by Ice

  Defining some Tables in SQL-Server which will be accessed via ODBC from MS-Access. I'm not sure about it, put i read somewhere that a primary key must bee named with 'aaaaaPK_ColumnName'. The 5 'a' should manage that the PK is listed first in the dialog for all key's in MS-Access. What do you think about that?

  Read the article

• How to Export SQL Server IMAGE data to Oracle's BLOB?

  - by alextansc

  I'm trying to export a table with IMAGE data type fields in SQL Server 2005 to a table with BLOB data type fields in Oracle 11g. What is the recommended way to perform this operation, assuming we have more than a thousand records to export at once?

  Read the article

• What is the best powershell script to restore an SQL Database?

  - by EtienneT

  To restore an SQL Server 2008 database, I would lile to be able to just do something like this in powershell: ./restore.ps1 DatabaseName.bak Then the powershell script would by convention restore it to a database with name "DatabaseName". It would disconnect any user connected to this database so that it can restore the DB. It would store the mdf and ldf in the default location. This would mainly be while developing on my personal machine. Just a quick way to restore a DB. Anyone has such a script? Thanks

  Read the article

• What can cause SQL Server Full Text Indexing automatic change tracking to stop working?

  - by Kjensen

  On a SQL Server 2008 server, we have a full text catalog in a database. The catalog is set to "track changes: automatic". What can cause this to not work sporadically, so the index is not updated?

  Read the article

• SQL Server Field with 8000 characters -- text or nvarchar?

  - by twpc

  I am adding a field to a SQL Server 2008 database. The field needs to accomodate up to 8000 characters (occasionally Unicode chars as well). Seems from my research that text data type is being deprecated. Go with nvarchar or stick with text anyway for such a large field?

  Read the article

• SQL-Server 2008 on a windows vista doesn't start.

  - by Ice

  Hi, i have installed a SQL2008 Server developer-Edition on my Dell Precision M90 Notebook with windows Vista, but the service dosen't start. SQL Server Configuration Manager shows MSSQLSERVER as stopped and an attempt to start this service fails. No entry in eventviewer... where to look? What might be the reason?

  Read the article

• Why does MS SQL Server Management Studio almost freeze up my computer while it restores?

  - by josh

  Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this should be since I have 4 gigs of ram and a dual core CPU. Thanks

  Read the article

• Is there a way to import a MS SQL .db.back (database backup) into PostgreSQL?

  - by joschmidt2

  I've received MS SQL backups from a client, I'm wanting to import/restore them into a PostgreSQL environment. Is this possible?

  Read the article

• Removing "Using temporary; Using filesort" from this MySQL select+join+group by query

  - by claytontstanley

  I have the following query: select t.Chunk as LeftChunk, t.ChunkHash as LeftChunkHash, q.Chunk as RightChunk, q.ChunkHash as RightChunkHash, count(t.ChunkHash) as ChunkCount from chunksubset as t join chunksubset as q on t.ID = q.ID group by LeftChunkHash, RightChunkHash And the following explain table: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE subsets ref PRIMARY,IDIndex,SubsetIndex SubsetIndex 767 const 522014 "Using where; Using temporary; Using filesort" 1 SIMPLE subsets eq_ref PRIMARY,IDIndex,SubsetIndex PRIMARY 771 sotero.subsets.Id,const 1 "Using where; Using index" 1 SIMPLE c ref IDIndex IDIndex 4 sotero.subsets.Id 12 "Using where" 1 SIMPLE c ref IDIndex IDIndex 4 sotero.subsets.Id 12 note the "using temporary; using filesort". When this query is run, I quickly run out of RAM (presumably b/c of the temp table), and then the HDD kicks in, and the query slows to a halt. I thought it might be an index issue, so I started adding a few that sort of made sense: Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment chunks 0 PRIMARY 1 ChunkId A 17796190 NULL NULL BTREE chunks 1 ChunkHashIndex 1 ChunkHash A 243783 NULL NULL BTREE chunks 1 IDIndex 1 Id A 1483015 NULL NULL BTREE chunks 1 ChunkIndex 1 Chunk A 243783 NULL NULL BTREE chunks 1 ChunkTypeIndex 1 ChunkType A 2 NULL NULL BTREE chunks 1 chunkHashByChunkIDIndex 1 ChunkHash A 243783 NULL NULL BTREE chunks 1 chunkHashByChunkIDIndex 2 ChunkId A 17796190 NULL NULL BTREE chunks 1 chunkHashByChunkTypeIndex 1 ChunkHash A 243783 NULL NULL BTREE chunks 1 chunkHashByChunkTypeIndex 2 ChunkType A 261708 NULL NULL BTREE chunks 1 chunkHashByIDIndex 1 ChunkHash A 243783 NULL NULL BTREE chunks 1 chunkHashByIDIndex 2 Id A 17796190 NULL NULL BTREE But still using the temporary table. The db engine is MyISAM. How can I get rid of the using temporary; using filesort in this query? Just changing to InnoDB w/o explaining the underlying cause is not a particularly satisfying answer. Besides, if the solution is to just add the proper index, then that's much easier than migrating to another db engine.

  Read the article

• Why the “Toilet” Analogy for SQL might be bad

  - by Jonathan Kehayias

  Robert Davis(blog/twitter) recently blogged The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads , in which he uses an analogy for why increasing the value for the ‘max worker threads’ sp_configure option can be bad inside of SQL Server.  While I can’t make an argument against Robert’s assertion that increasing worker threads may not improve performance, I can make an argument against his suggestion that, simply increasing the number of logical processors, for example from...(read more)

  Read the article

• Microsoft SQL Server High-Availability Videos and Q&A Log

  - by KKline

  You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt . Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high availability techniques including database mirroring, transactional replication, and Windows clustering services. You can see videos of these presentations at the...(read more)

  Read the article

• Sep 10 Week - I'll be on the West Coast Speaking in Irvine and San Fran

  - by RickHeiges

  In my role as a Solutions Architect for Scalability Experts, I often get to present to customers about the work that we performed. Unfortunately, this is often on short notice and I can't coordinate a trip to participate in a User Group Meeting. Next week, I was able to coordinate my west coast trip to be able to present. I am heading to Irvine at the MTC on Sepember 11 and San Francisco at the MSFT offices on Sep 13 to speak to customers who want to learn more about SQL Server 2012.To register for...(read more)

  Read the article

• Rumor Mill: New Features SQL 11

  - by Mike Femenella

  For those of you that remember the old Mike Myers SNL skit, talk amongst yourselves..I’ll give you a topic: This is purely based on 1 conversation with 1 person from the mothership (Microsoft). SQL 11 is in the works and supposedly includes readable mirrors and in the version beyond that read/write mirrors. Given the name I would assume that release would be (drum roll) 2011 some time. Discuss.

  Read the article

• Hugh Bin-Haad's SQL Rumours

  - by Paul Nielsen

  Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it http://www.simple-talk.com/sql/editors-corner/insider-insights/ Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

  Read the article

• Hugh Bin-Haad's SQL Rumours

  - by Paul Nielsen

  Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it http://www.simple-talk.com/sql/editors-corner/insider-insights/ Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

  Read the article

• Good practices - database programming, unit testing

  - by Piotr Rodak

  Jason Brimhal wrote today on his blog that new book, Defensive Database Programming , written by Alex Kuznetsov ( blog ) is coming to bookstores. Alex writes about various techniques that make your code safer to run. SQL injection is not the only one vulnerability the code may be exposed to. Some other include inconsistent search patterns, unsupported character sets, locale settings, issues that may occur during high concurrency conditions, logic that breaks when certain conditions are not met. The...(read more)

  Read the article

• Simon Sabin has a great discount for the SQL Server Masterclass

  - by Testas

  Check out Simons blog post to get a discount of £100 for this event http://sqlblogcasts.com/blogs/simons/archive/2010/05/14/paul-and-kimberly-are-coming-the-uk.aspx   Remember as well  Pencil the 17th June in your diary, send an email [email protected] with the title of Masterclass in the subject line. On Friday 25th May we will draw out a name and the winner will have free entrance to a must see seminar on SQL Server from two of the industry’s leading experts. Thanks Chris

  Read the article

• Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Server 2008 R2

  As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Analysis Services in Windows Firewall for user connectivity.

  Read the article

• SQL Server 2005 Paging – The Holy Grail

  Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.

  Read the article

< Previous Page | 389 390 391 392 393 394 395 396 397 398 399 400  | Next Page >