Search Results

Search found 27339 results on 1094 pages for 'sql dmv'.

Page 244/1094 | < Previous Page | 240 241 242 243 244 245 246 247 248 249 250 251  | Next Page >

• Password protected PDF/Excel reports using SQL Reporting services

  - by balaweblog

  I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf. Is there any way to protect the report.

  Read the article

• Azure Tables or SQL Azure?

  - by Phil Wright

  I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL Azure for storing my application data?

  Read the article

• Resources for high performance SQL Server database design

  - by Nathan Ridley

  I'd like some suggestions for online resources (blogs, guides, etc - not forums) to help me become good at designing high performance SQL Server databases that operate with large amounts of data and have heavy loads in terms of data turnover and queries per minute. Suggestions?

  Read the article

• Linq to SQL table inheritance in ASP.net Dynamic Data

  - by themapguyde

  I have a Linq to SQL data model that uses single table inheritance. I created a new ASP.net Dynamic Data web site with all table scaffolding enabled, but I can't see any of the derived classes in my data model being scaffolded. Is this by design?

  Read the article

• SQL - Order against two columns at the same time (intersecting)

  - by Alex

  I have a table with the fields CommonName and FirstName. Only either field has data, never both. Is there a way to order rows in an intersecting manner on SQL Server? Example: CommonName FirstName Bern Wade Ashley Boris Ayana I want records ordered like this: CommonName FirstName Ashley Ayana Bern Boris …

  Read the article

• joining null in MS SQL server, Oracle and informatica

  - by jest

  hi! I've two tables to join with a column(say emp_id)..if emp_id in both the tables have null values, how'll MS SQL server and Oracle treat??? Coz, i read that informatica will neglect the NULL rows when joining..if i handle the null, by substituting -1, a cross-join will happen which i don't want.. what can i do here? I cannot completely…

  Read the article

• Updating multiple tables at the same time in Linq-to-SQL

  - by kiran

  How do I update two tables at the same time using Linq-to-SQL? var z = from a in db.Products join b in db.ProductSubcategories on a.ProductSubcategoryID equals b.ProductSubcategoryID join d in db.ProductCategories on b.ProductCategoryID equals d.ProductCategoryID …

  Read the article

• Parsing SQL in .NET

  - by Eli

  I'm trying to build a .NET Managed data provider and I need to be able to parse SQL commands. What are good, free (as in beer) objects to do this? - I haven't seen any standard .NET assemblies for this yet. Thanks, Eli.

  Read the article

• Shrink Sql Server database

  - by hani

  My SQL Server 2008 database file (.mdf) file is nearly 24 MB but the log file grown upto 15 GB. If I want to shrink database what are the important points to take into consideration? Will shrink causes any index fragmentation and does it affect my database performance?

  Read the article

• SQL Server 2005 Installation on Windows 2000 Server

  - by Raghu

  Hi All, We want to install sql server 2005 on Windo ws 2000 Server. We are able to install database service engine, analysis services engine and integration services. But we are unable to install workstation components like SSMS. Does anybody faced this problem? What is the fix for this? Thanks, Raghu

  Read the article

• Timestamp as part of composite primary key?

  - by Curtis White

  I get this error when using linq-to-sql with timestamp as part of a composite primary key: "The primary key column of type 'Timestamp' cannot be generated by the server." I'm guessing this may be due to the fact timestamp is just a row version thus perhaps it must be created after the insert? Or...

  Read the article

• SQL Server 2008 Spatial Clustering

  - by illvm

  I am trying to group points of geospatial data based on density and relative distance. Is there a way that this can be done in SQL Server 2008 using the spatial features or would it be better to translate the data into graph data and use a graph clustering algorithm?

  Read the article

• Locking User account created under Windows Authentication in SQL Server

  - by Santhosha

  Hi, As per my project requirement i need to lock a user in SQL Server(Which is created using Windows Authentication). Is there any way to do this? Thanks for the help Santhosh

  Read the article

• Execution time of ALTER COLUMN

  - by Tommy Jakobsen

  Having a table with 60 columns, and 200 rows. Altering a BIT column from NULL to NOT NULL, now has a running execution time of over 3 hours. Why is this taking so long? This is the query that I'm execution: ALTER TABLE tbl ALTER COLUMN col BIT NOT NULL Is there a faster way to do it, besides creating a new column, updating it with values…

  Read the article

• SQL Server 2008 Reporting Service 2008 the page margins not set while exporting to Excel

  - by BIPIN

  Hi, While using new SQL Server 2008 Reporting Service 2008 the page margins that I specify in Report Properties Page Setup do not seem to flow through to Excel when exported? They always seem to be set to Top & Bottom: 2.5cm, Left & Right: 1.9cm, no matter what I set them to in the report. This was working perfect in 2005 version. …

  Read the article

• Wingding chars in sql server 2005

  - by Savvas Sopiadis

  Hi everybody! In a winforms application i 'm storing one Wingdings char in a SQL Server 2005 field of type NVARCHAR(1). Storing, retrieving and showing up this char in a control works fine. The problem i'm facing is this: how to search for records which have a specific wingding char value: for example Select * from table where…

  Read the article

• Oracle PL/SQL: Performance of CLOB data type in PL/SQL

  - by drupalspring

  If I use many CLOB variables in the PL/SQL stored procedure to store many long length string , are there any performance issues? Is the length of the CLOB is also variable? Are there any known limitations/disadvantages for CLOB instead using varchar2 and long?

  Read the article

• MYSQL Installation Problem...

  - by Gopal

  I was downloaded the MYSQL from this link http://dev.mysql.com/downloads/mysql/ But i cannot able to find the Installation file... How to create database & Table in mysql? It will work like SQL server or ? Need Help

  Read the article

• Using Excel to work with SQL data (read/write)

  - by Tyler Brock

  I have a ton of data in a sql database which I would like to be able to import and display in excel (I can already do this) and additionally modify or append to the dataset within excel and write the changes/additions back to the database. What is the best way to go about doing something like this? Please let me know, thanks!

  Read the article

• use Data Annotation to my Linq to SQL

  - by Khalid Omar

  i have a mvc web project and i'm using linq to sql i'm using dataannotaion like this public class ClientValidation { [Required] public string name1st { get; set; } } then in the linq class i add that above client class [global::System.Data.Linq.Mapping.TableAttribute(Name = "dbo.Client")]…

  Read the article

• Linq-to-SQL question

  - by c11ada

  hey all, im really new to linq-to-SQL so this may sound like a really dumb question, i have the following code var query = from p in DC.General where p.GeneralID == Int32.Parse(row.Cells[1].Text) select new { p.Comment, …

  Read the article

• SQL Server online backup with MozyPro

  - by Erick Sasse

  Anyone using MozyPro to backup SQL Server databases? I'm concerned about the way it does the backup. It just copies data files the way they are. Not using the backup database command. Is it safe?

  Read the article

• Print DataBase Schema in Sql Server Compact Edition

  - by hosseinsinohe

  Hi All I Want Print DataBase Schema in "Microsoft Sql Server Compact Edition". Maybe Exist Some Tools For it. How Can I do it?

  Read the article

• Case insensitive duplicates SQL

  - by hdx

  So I have a users table where the user.username has many duplicates like: username and Username and useRnAme john and John and jOhn That was a bug and these three records should have been only one. I'm trying to come up with a SQL query that lists all of these cases ordered by their creation…

  Read the article

• SQL - fetch the row which has the Max value for a column

  - by Umang

  Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, the Value for each UserId that has the latest date. Is there a way to do this simply in SQL? (Preferably Oracle) Thank in advance! [Update:] Apologies for any ambiguity: I need to get ALL…

  Read the article

< Previous Page | 240 241 242 243 244 245 246 247 248 249 250 251  | Next Page >