Hi, how big (binary(xy)) should I make my table column in SQL database if I want to store there pictures taken by camera - that means variable size up to.. I don't know.. 7MB? But if I should rather limit the size up to 2MB or something, I would. Whats your opinion? EDIT Or where else should I store them? I am building a web gallery us...
I am creating a database in SQL Server 2005 and cannot remember the "CREATE SCHEMA" statment, if that's it, to create a new schema similar to ".dbo". I did it last night, but I cannot remember how and cannot find the article. What I'm trying to accomplish is a database organization like that of the AdventureWorks database where the tab...
I'm working with a client who has just upgraded from SQL 2000 to SQL 2008 and their view query times have gone up a lot. I had a look at the views and couldn't see much wrong with them. When I ran the view directly on the server, the times were OK. When I ran via Management Studio remotely, the time goes from 2secs to about 30secs. So,...
I have a background process that is constantly inserting into a table in real-time. It could be thousands of inserts an hour (with a few updates). This same table is used by the web application to get some data needed to display to the user. Currently whenever the background process runs its inserts/updates, the web app seems blocked a...
I'm developing a web app and currently using sql server 2008 for it. But, I am considering moving to another database (simpledb) for improved performance. I have a background process that inserts up to 10000 rows every hour into one specific table. That table is also read from to display data in the web application. When the background...
Hi everyone I need to filter out junk data in SQL (SQL Server 2008) table. I need to identify these records, and pull them out. Char[0] = A..Z, a..z Char[1] = 0..9 Char[2] = 0..9 Char[3] = 0..9 Char[4] = 0..9 {No blanks allowed} Basically, a clean record will look like this: T1234, U2468, K123, P50054 (4 record examples) Junk d...
Hello, I have a problem with some SQL queries that are wrapped inside a transaction. Here's how the code looks like: using (SqlTransaction dbTrans = conn.BeginTransaction()) { using (SqlCommand cmd = conn.CreateCommand()) { for(Parameters p in parameterList) try { //execute insert commmand } catch { //log...
I've got two SQL Server tables authors, and articles where authors primary key (AuthorID) is a foreign key in the articles table to represent a simple one-to-many relationship between authors and articles table. Now here's the problem, I need to issue a full text search on the authors table based on the first name, last name, and biograp...
I am relatively new to programming. My work basically revolves around data and analysis. I want to create a simple asp.net page which shows huge chunk of data from the database. There could be a millions of rows of data which is used for different kinds of analysis/searchin/filtering etc.. Should I write paging logic at the front end ...
Given a query like: SELECT table1.field1 FirstField, table2.field2 SecondField FROM table1 INNER JOIN table2 ON table1.FK = table2.PK WHERE table1.somefield = 'somevalue'; My objective is to return a strongly typed result set using .netTiers. I assume that I cannot use a view because the WHERE clause needs a parameter, whi...
Hello, I am having an issue that I can't seem to figure out. Hopefully somebody can point me in the right direction, or give me other ideas to look into. I won't provide much code now because honestly I don't think it's a coding issue. First, I have an ASP.NET 3.5 web application. I am using ASP.NET Membership libraries for my authen...
I am using SQL Server Reporting Services 2008. I have one dataset which is shared among several reports--each report groups or formats data differently. Is it possible to configure things so that the data is pulled from SQL Server when one of these reports is built and then cached within SSRS for a configurable period of time? Assume tha...
I have a table and a text file. Once the records in the table copied into textfile, the records will be deleted. But the table are still in used and will be inserted with a new records from time to time(by another program). I what to do checking on How to make sure that if there are no records in the table, the program will never copy i...
I'm trying to connect to SQL Server on Ubuntu 9.04 using Ruby. I translated and followed all the steps outlined in getting OSX talking to SQL Server from here: http://toolmantim.com/articles/getting_rails_talking_to_sqlserver_on_osx_via_odbc Everything is working on the FreeTDS and unixODBC end. I can see and query the database using t...
I am looking at FILESTREAM attribute in SQL Server to store files in it. I understand it stores the files on hard drive and stores the file pointer/path information in DB. Also, maintains transactional consistency in the process. There also seems to be a limitation "FILESTREAM data can be stored only on local disk volumes" for the FILES...
Edit: OK I asked the wrong question here. I'm going to be coding a stored proc that affects a lot of data, so I need to know the quickest, easiest way to roll back the data to the original state after I run a test. Old question: I have a development database holding live data. This needs to be obfuscated for privacy, particularly com...
I'm using SQL Server 2005 with a table with a primary key field with the type varchar(40). I have to get the last inserted record's primary key value. I have tried scope_identity but it is not working. How can I get this? ...
Hi, I am converting a console application to run from Service Broker in SQL Server 2005. The application makes heavy use of DataSet. Are DataSets supposed to work in SQLCLR? How do I define the connection to use? Is there any documentation about this? Thanks for your help! ...
Hi, Is there any API SQL Server 2008 offers for .net application to create and grant access authorities? Thanks! ...
How can I restrict my users to stop getting Log in / accessed into my Database by Enterprise Manager or by any other way in SQL Server 2000? ...