Make Money Fast by Transforming 6 Dollars into Thousands of Dollars Here's a legal way to supplement your income by earning thousands of dollars using the standard mail delivery service. IT WAS PROVEN on Oprah and is COMPLETELY LEGAL! You Can Laugh at Money Worries if You Follow This Simple ...more >>

this didn't fix the error for me From http://www.google.com/search?hl=en&q=sql+server+books+online+"no+search+provider+has+been+selected" Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I forgot that newsgroup-format does not allow the Euro-sign. The data arrives in Euro or in DM... "Tobias Frei" <t.frei@eagle-peak.de> schrieb im Newsbeitrag news:%23Zga5mSHIHA.4712@TK2MSFTNGP04.phx.gbl... > Hello, > i have the following problem: I like to export data from a sql-view into ...more >>

Hello, i have the following problem: I like to export data from a sql-view into an excel sheet. The data arrives in the corresponding columns but i have the problem that in one column data arrives with annotation "?" as well as "DM". In SQL-Server, I updated the columns with data type money...more >>

Hello, Please help in the following problem: I cannot create database beacuse of error: SQL Server does not allow for remote connections. In fact, I use .NET utility program: aspnet_reqsql -S SQLEXPRESS -E -A all -d "D:\MIM-Magazyn\App_Data\aspnetdb" and I receive the following messag...more >>

It doesn't work that way, you need to cross apply the sql text like this: SELECT t.[text] AS [Adhoc Batch or Object Call], SUBSTRING(t.[text], (qs.[statement_start_offset]/2) + 1, ((CASE qs.[statement_end_offset] WHEN -1 THEN DATALENGTH(t.[text]) ELSE qs.[statement_end_offset] ...more >>

MERGE is like PIVOT, just some syntatic sugar:) The real issue is having a 'view' aware of relationships between tables and making a decision of what operation to perform when it is hit with a row. This is what I would like in Sql Server: http://beyondsql.blogspot.com/2007/06/dataphor-intelligen...more >>

Hi Andrew, I've tried the following but with the database name in place of {db} and so on. It does not get me anything. Does that mean there is no execution plan in the database for it. I've run the stored proceedure so there should be something there. SELECT * FROM sys.dm_exec_query...more >>

It is not a stored procedure it is a view. More specifically a Dynamic Management View or DMV. You can find details in BooksOnLine. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Edmund" <die_spambot@hatespam.com> wrote in message news:OEUS7E%23GIHA.280@TK2MSFTNGP03.phx.gbl... ...more >>

Not with any of the released products. SQL2008 will include a MERGE command that does exactly this. Currently you need to do something like this: UPDATE MyTable SET Name = 'Bill WHERE UserID = 5 IF @@ROWCOUNT = 0 INSERT INTO MyTable (Name, USERID) VALUES ('Bill,5) -- Andrew J. ...more >>

Hello, is it possible to create one statement that updates a table if a record is already present and inserts new data if the record does not exist before? Something like (Pseudo-Code!!!): UPDATE_OR_INSERT MyTable SET NAME = 'Bill', USERID=5 WHERE USERID=5 That should update the fi...more >>

Alternatively, open up Management Studio and connect to your instance. Go to that database which stores your tables and right click on that database. You'll see Tasks and Import and Export in that menu. You can use these stuff to import into your tables and export from them. P.S. If you ...more >>

Hi Andrew, What is the the sys.dm_exec_query_stats DMV? I've looked in the systems stored procedures in the database but do not see one by that name. E "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:%23$A3sLbGIHA.1208@TK2MSFTNGP03.phx.gbl... > If you are on SQL ...more >>

Check out bcp.exe in the BOL. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Jim" <stopspam@redmond.com> wrote in message ...more >>

"tdstr" <tdstr@booger.net> wrote in message news:uqT4K4%23FIHA.484@TK2MSFTNGP06.phx.gbl... > Total SQL newbie here. Hope I'm posting in the correct group. > > I have a Exchange 2003 server that archives all email to a large(55GB) SQL > database. I have a situation where I have to export sev...more >>

Using SQL Server 2005 Dev and SQL Server Manager, how do I dump a table and it's data to a file then import it into another table? I see the options "Script Table as" and then the Create To, Drop To, etc. options, but all of those only put the structure in the file. What am I missing? Th...more >>

On Sun, 28 Oct 2007 12:00:00 -0700, Barry Burke wrote: >Whats the 'normal' maximum count of tables in a join and what if there are >views involved. >What about nesting views Hi Barry, Tom answered the first question. Re the second questions - views are somewhat like macros: they get ...more >>

Sorry but I just realized you also wanted the reason for a recompile as well. That can only be found via a trace as Adam suggested AFAIK. Since the plan is removed and replaced with a new one each time it recompiles the previous data is lost. -- Andrew J. Kelly SQL MVP Solid Quality M...more >>

If you are on SQL 2005 have a look at the sys.dm_exec_query_stats DMV. The Creation_Time should give you what you want. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Edmund" <die_spambot@hatespam.com> wrote in message news:OW10fSXGIHA.4584@TK2MSFTNGP03.phx.gbl... > > Thanks ...more >>

A single query - including a view - can access up to 256 tables. Typically, joins involve 2 - 4 tables but can often go beyond that. It depends on the app and how normalized your schema is. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE...more >>

Whats the 'normal' maximum count of tables in a join and what if there are views involved. What about nesting views...more >>

Thanks Adam, I'll give this a try. By the way, if any does know how to select this information from the system tables, I'm still checking this thread for an answer. "Adam Machanic" <amachanic@IHATESPAMgmail.com> wrote in message news:04F4785E-C06F-4282-A550-93D5572640F8@microsoft.com......more >>

I am not aware of any way to query that information from the system catalog. What you can do if you want to start monitoring recompiles is set up a server-side trace and watch the SP:Recompile event. You can periodically insert the trace data into a table, and then you will have your own runn...more >>

On Fri, 26 Oct 2007 09:39:49 -0700, HX wrote: >How can I concatenate specific fields across records in a query? Hi HX, If this is formatting for output, then the answer is that you should let the client handle it. This will always be a slow operation on the server. For versions of SQL ...more >>

Total SQL newbie here. Hope I'm posting in the correct group. I have a Exchange 2003 server that archives all email to a large(55GB) SQL database. I have a situation where I have to export several emails from that database. However at this point I am clueless on how to accomplish this. A...more >>

How can I concatenate specific fields across records in a query? Here is the layout of my table: CREATE TABLE [rdb].[image_use]( [RecordID] [int] IDENTITY(1,1) NOT NULL, [ImageID] [int] NULL, [ModuleID] [int] NULL, [LessonID] [int] NULL, [TopicID] [int] NULL, [PageID] [varchar](50)...more >>

Hello, Does anyone know how to select the last time a stored procedure was compile and which recompile condition caused it? Thanks, E ...more >>

Which version of SQL Server are you using? I know that when using the Restore Database... option in Management Studio (2005), you can just change the name of the Database the backup is being restored to. For example: Destination for restore - "To database:" DBname_Test Source for res...more >>

Have a look at these: http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking considerations http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues http://www.support.microsoft.com/?id=317375 Log File Grows too big http://www.support.microsoft.com/?id=11013...more >>

My transaction log file is pretty big and am trying to run maintenance plan which is setup to clear the unused space etc. But it does not run. It keep erroring out saying administrator has no rights to run. Is there any other way of running or shirinking log file? ...more >>