Search Results

Search found 95364 results on 3815 pages for 'home server'.

Page 548/3815 | < Previous Page | 544 545 546 547 548 549 550 551 552 553 554 555  | Next Page >

• Will performance of a SQL server degrade if the DB can't fit in the memory?

  - by Carl Hörberg

  Will the performance of a SQL server drastically degrade if the database is bigger than the RAM? Or does only the index have to fit in the memory? I know this is complex, but as a rule of thumb?

  Read the article

• Backspace on Cygwin Screen not working for Windows 2003 Server?

  - by qor72

  I updated a working Cygwin/Screen setup on Windows 2k3 Server to Cygwin v1.7.2 and Screen 4.00.03. After updating, backspace no longer works. I haven't made any changes to my system or configuration. The Cygwin update went fine, and I don't have any custom changes in /etc. Any ideas?

  Read the article

• How rigid is the max size of a VARCHAR in SQL Server?

  - by thinknow

  i.e. if I create a VARCHAR(50) field, what happens if I try to assign it a value that's 100 characters long? Will SQL Server let me do this? Is it somehow less efficient?

  Read the article

• What the linq query for SQL like and Soudex for sql server 2008?

  - by KentZhou

  In sql server, we can issue sql to get data like select * from table where column like '%myword%' select * from person where Soundex(LastName) = Soundex('Ann') what's the linq query to match above sql?

  Read the article

• How to find out whether sql server login has any user mapped to using SMO.

  - by Ybbest

  I need to write a function to delete the login in the database if it does not have any users to map to using SQL Server Management Objects (SMO). How can I achieve this ?

  Read the article

• Is there a way to add a virtual directory to Visual Studio Development Server?

  - by David Hodgson

  Hi, I'm using the Visual Studio Development Server, with a specific port. Is there a way to add a virtual directory to it? EDIT: Sorry, I wasn't very clear. I'd like to be able to add one or more virtual directories to arbitrary physical directories. For instance: http://localhost/c_drive/ would map to C:\, http://localhost:/d_drive/ would map to D:\, etc.

  Read the article

• Does Win 2008 r2 x64 server come with .net 3 sp1 package already installed?

  - by luckyluke

  same as in title? I have a test server with mentioned OS and my app is .net 3.5 based. I do want to know if win 2008 r2 comes with service pack 1 for .net 3.5 from the box. And does it come with .net 3.5 sp1 family update as WELL, since after I downloaded the update, the installer says I do not have software required to update. Could some win 2008 guru perhaps explain it to me? thanks luke

  Read the article

• SSAS dimension source table changed - how to propagate changes to analysis server?

  - by Phil

  Hi, Sorry if the question isn't phrased very well but I'm new to SSAS and don't know the correct terms. I have changed the name of a table and its columns. I am using said table as a dimension for my cube, so now the cube won't process. Presumably I need to make updates in the analysis server to reflect changes to the source database? I have no idea where to start - any help gratefully received. Thanks Phil

  Read the article

• How to automatically generate documentation of stored procedures of SQL Server 2008?

  - by gilbertc

  How to automatically generate documentatation of stored procedures of SQL Server 2008 like doxygen does to codes? I read about hyperSQL but it doesn't work nice with Windows. Thanks! Gil.

  Read the article

• How to dump memory in windows 2008 64bit server?

  - by Guy Bertental

  Hi, I want to analyze memory leak in my ASP.NET application, How can I dump memory in windows 2008 64bit server? thanks, Guy Bertental

  Read the article

• Is it possible to set a SQL server columns' description using a fluent nhibernate map?

  - by Simon

  I am using my fluent nhibernate mappings to generate my MS SQL Server database. I would like to be able to set a columns' description as part of this generation.

  Read the article

• Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it fro

  - by Craig Johnston

  Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it from a file? If I don't do this, I get a "User login failed" when trying to access the database using this username from apps.

  Read the article

• How to get last full MS SQL Server error message?

  - by JohnM2

  I am aware of: SELECT @@ERROR but it will give me only an ERROR CODE (a number) and I need a full text message like: Cannot insert duplicate key row in object 'dbo.TABLE_NAME' with unique index 'IX_ID_unique'. The statement has been terminated. How can I do that in MS Sql Server 2005 ?

  Read the article

• In sql server, is there any way to check whether the schema change will impact on the stored procs?

  - by ziang

  In SQL Server, is there any way to check whether the changes in the schema will impact Stored Procedures (and/or Views)? For example a change of the column name in one table, may break some Stored Procedures; how to check the impacted stored procs?

  Read the article

• Permission denied while using mkdir on a windows server.

  - by Jowkar

  Hi, the problem is, im using a leased windows server, and im trying to create a directory using php function mkdir, whichever path i try gives the same result. im using absolute something like this. mkdir('D:\Hosting\3105674\html\lepsiprisma\hola',0777);

  Read the article

• In SQL Server, how can I execute a piece of tsql against all databases in an instance?

  - by Yousui

  Hi guys, In SQL Server, how can I execute a piece of tsql against all databases in an instance? Great thanks.

  Read the article

• SQL Server: How to get a subitem of sp_helplanguage ?

  - by Quandary

  Question: I can get the SQL Server database language by querying: SELECT @@language And I can get further info via EXEC sp_helplanguage How can I query for a column of sp_helplanguage where name= @@language I do SELECT * FROM sp_helplanguage WHERE name='DEUTSCH' but that obviously doesn't work. What's the correct way to query it ?

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• In Visual Studio 2008, Right-Click on a Data Connection in Server Explorer > New Query, Can I change

  - by Jon Erickson

  I hate the standard Query window that comes up when you select new query on a data connection in server explorer, I'd much rather have a T-SQL Editor come up. Is this possible? Maybe not replace that functionality but a shortcut key or something that would bring up a T-SQL editor?

  Read the article

• Does SQL Server have any kind of magic undo feature?

  - by Andrew G. Johnson

  Long story short is I tried to quickly update a single row in SQL Server using the Management studio and just typed UPDATE table SET column='value' and forgot the WHERE other_column='other_value' portion. Went for lunch, came back and theres 15 unread emails waiting for me. Happened about an hour ago, waiting for the database guy to come back to see when the last backup was. There's no magic UNDO feature though is there?

  Read the article

• How to change this mysql select into sql server select statement?

  - by Pandiya Chendur

  I use this mysql statement for concating description which has a length greater than 30.. select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30), '.....'),description) as description from table How to change this mysql select into sql server select statement?

  Read the article

• How to turn string into readable by php server way? (ActionScript)

  - by Ole Jak

  So I know that my server on real form submit turns %CE%EB%E5%E3+%DF%EA%F3%F8%EA%E8%ED into ???? ??????? . How to peform string transfer from ???? ??????? into %CE%EB%E5%E3+%DF%EA%F3%F8%EA%E8%ED using ActionScript? (Its ok if a space character as %20, not + , PHP should handle that fine.)

  Read the article

• How to retrieve unicode data stored directly in non-unicode field as varchar format in sql server

  - by Samujjal

  I have to create a C# application which displays unicode data in a textbox. But the SQL server column storage has varchar data which contains unicode data. But since varchar is non-unicode based it displays character strings like "????????". Well the problem i am facing is i cant change the column type as there are other dependent application running on it.

  Read the article

• SQL Server - how to set (nolock) hint as a default?

  - by opensas

  is there some way to tell sql server to use the (nolock) hint or every select in a stored procedure? is pretty tiresome to add it to each an every select....

  Read the article

• When do I need to use Begin / End Blocks and the Go keyword in SQL Server?

  - by Braveyard

  Can someone tell me when and where I need to use begin and end blocks in SQL Server? Also, what exactly does the Go keyword do? Thanks in advance...

  Read the article

< Previous Page | 544 545 546 547 548 549 550 551 552 553 554 555  | Next Page >