Search Results

Search found 38336 results on 1534 pages for 'sql wait types'.

Page 572/1534 | < Previous Page | 568 569 570 571 572 573 574 575 576 577 578 579  | Next Page >

• select xml data column into flat reporting table

  - by Bernard

  We have a xml column in SQL Server 2008. We need to do reporting off the data in the xml so we're going to select the xml into a flat table. The flat table has columns that correspond to various nodes in the xml. What is the best way to do this using SSIS? Is this a good approach? Or should we just try and write the reports directly off the xml column?

  Read the article

• Get ms sqlserver 2008 managament studio icons

  - by alex

  I want to get icons from sql server management studio 2008. Is it free ? If so where can I download it ? maybe some pirate copy ?

  Read the article

• Im at a lost what to read and study! Db Design or Code Complete?

  - by ajushi

  I've been a PHP programmer for 3 years. I really want to improve myself and I think reading more helps but I'm confused where to concentrate next. I have two choices, read more about DB design and advanced SQL or should I read Code Complete fully?

  Read the article

• Inserting a null value into the database.

  - by J Harley

  Good Morning, Say I have an insert statement: Insert INTO tblTest (fieldOne,FieldTwo,fieldThree) VALUES ('valueOne','valueTwo','null') This statement doesn't seem to want to insert a null value into the database... I have also tried to insert the word "nothing". Has anyone any ideas how to make this work? I am using SQL server 2005.

  Read the article

• Openquery - unable to begin a distrubuted transaction

  - by dc2

  I am trying to use open query to run a stored procedure in a remote database, and insert it into a table in my local database: -- this works exec remotesvr.sys.dbo.golden_table 'some', 'parameters' While the above works out, I try the following: insert into my_local_table exec remotesvr.sys.dbo.golden_table 'some', 'parameters' I get a SQL error to the effect of 'unable to begin a distributed transaction'. Is there any way around this?, i.e. can I execute take the results of a remote stored procedure and put its contents in a local table?

  Read the article

• Help with simple query - why isn't an index being used?

  - by Randy Minder

  I have the following query: SELECT MAX([LastModifiedTime]) FROM Workflow There are approximately 400M rows in the Workflow table. There is an index on the LastModifiedTime column as follows: CREATE NONCLUSTERED INDEX [IX_Workflow_LastModifiedTime] ON [dbo].[Workflow] ( [LastModifiedTime] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) The above query takes 1.5 minutes to execute. Why wouldn't SQL Server use the above index and simply retrieve the last row in the index to get the maximum value? Thanks.

  Read the article

• Which is better: Ad hoc queries, or stored procedures?

  - by Will

  Assuming you can't use Linq for whatever reason, is it a better practice to place your queries in stored procedures, or is it just as good a practice to execute ad hoc queries against the database (say, Sql Server for argument's sake)?

  Read the article

• How to connect to a database from VC++/CLI .NET 4.0

  - by abatishchev

  How to connect to a database (any natively supported by .NET) - SQL Server 2008 or Access - from a Windows Forms application written on VC++/CLI (compiler ver. 16.0 from .NET 4.0)

  Read the article

• Maximum capabilities of MySQL

  - by cdated

  How do I know when a project is just to big for MySQL and I should use something with a better reputation for scalability? Is there a max database size for MySQL before degradation of performance occurs? What factors contribute to MySQL not being a viable option compared to a commercial DBMS like Oracle or SQL Server?

  Read the article

• Option To AutoFormat Query Syntax in SSMS 2005 or 2008?

  - by dragon77

  In TOAD (for SQL or Oracle), there is a simple AUTOFORMAT button that will nicely format your query - I couldn't find that option in SSMS 2005, but was advised by a co-worker that it was available in SSMS 2008. I am unable to locate the option there either. This is VERY helpful when pasting a query from another source. Thanks for any assistance.

  Read the article

• How to user IN operator in Linq?

  - by Umapathy

  Query: Select * from pu_Products where Part_Number in ('031832','027861', '028020', '033378') and User_Id = 50 and Is_Deleted = 0 The above mentioned query is in SQL and i need the query might be converted into Linq. Is there any option using the "IN" operator in Linq?. can you convert above mentioned query into Linq?

  Read the article

• Coping Indexes from old database to new one?

  - by AmRoSH

  Hi, I converted an old sql server database from 2000 to 2005 and forgetten to add old indexes to the new db. is there any way to copy the old indexes to the new db? any help?

  Read the article

• Refreshing data in a java.sql.ResultSet

  - by llm

  I have a java.sql.ResultSet object containg data from a query that was run. How do I refresh the data in the ResultSet to reflect the current data in the database? Thanks!

  Read the article

• In mysql or postgres, is there a limit to the size of an IN (1,2,n) statement?

  - by Kyle

  I've got quite a few SQL statements like such: SELECT foo FROM things WHERE user_id IN (1,2,3..n) Is there a known limit to the number of elements that will safely fit in an IN clause like that?

  Read the article

• Linking database column to dropdown control in ASP.Net

  - by kunal

  I am using c# with asp.net and SQL Server 2005 as backend. I want to use dropdown list control in a form to populate a textbox. The dropdown control is linked to a column in the database. How can I code this in c#?

  Read the article

• Rails activerecord to_sql_string?

  - by pepernik

  I've seen somewhere but can not remember. How to get an SQL from ActiveRecord object? Client.find(1).to_sql_string

  Read the article

• best encryption method sql server asp.net c#

  - by mazhar kaunain baig

  What is the most standard encryption technique used in sql server for asp.net c# enterprise level application? . i am talking with respect to standards like md5 or sh1 etc, hashing

  Read the article

• How to generate script/stored procedure to copy data from one database to another

  - by aein

  I had to restore may database to 1 day erlier, so My database is missing data from a day before, and this databse has been used by users since the restoration. How do I generate script/stored procedure to copy just the missing data from the backup database into my current database. There are PK and FK relationships that need to be considering. I'm using SQL server 2005 Thanks for your help. Aein

  Read the article

• On Update: Auto Update Date/Time Field

  - by Abs

  Hello all, Is there an equivalent of MySQLs on update field for SQL server? With both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses, the column has the current timestamp for its default value, and is automatically updated. What I am looking for is to have a date/time field and every time I update a record it updates the field with the date/time it was updated automatically? If it doesn't exist, I guess I'll have to go manual. Thanks all

  Read the article

• ms-access: difference between .value and .text

  - by every_answer_gets_a_point

  i am passing values from a textbox into a sql statement in ACCESS i do not understand the difference in the usage of these two properties when i set the the .text property to something, how does the .value property get affected? when i do want something to be displayed in the textbox should i be using the value or text property?

  Read the article

• How to manipulate sql connection string in C#

  - by Liveonthree

  Hi i'm trying to manipulate the sql connection string so instead of running the original copy of our database it runs from the copy one folder up in our C# project.

  Read the article

• Excel : sum of values depending of other values

  - by gregseth

  Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7

  Read the article

• is it possible to add line from Database to text file in the server ?

  - by Gold

  hi i have sql-server 2008 database that in the main server. i have 10 terminals that connect to this server and work against the database. i need that every new inserting to database through any terminal - in the server this line will inserting to text file (every line) can i do it ? thank's in advance

  Read the article

• Anything like GROUP BY that gives you the max value'd field instead of the min?

  - by William

  I'm trying to get the results from this question (SO 2429348 - Help with a SQL query) except I need it to return values 1 and 3.

  Read the article

• How to speed up saving data to database over internet?

  - by robert_d

  I am using C#, Entity Framework and SQL Server 2008 Express. I am connected to the database over internet. What is the best method to speed up saving/updating data to database? It takes 60 seconds to save 140 records to database.

  Read the article

< Previous Page | 568 569 570 571 572 573 574 575 576 577 578 579  | Next Page >