Import Excel spreadsheet columns into SQL Server database
I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option. any easy code options? Thanks newbie ...
sql-server-2008
SQL Server 2008 Management Studio - "Show policy health state for all nodes"
What does "Show policy health state for all nodes" option do in SQL Server 2008 under the Object Explorer? ...
What can cause the failure of an SSRS Report on the Reportserver on Rendering?
Details are as follows: Environment: SSRS 2008 Server, SQL Server 2008 for database, Report Developed in SQL Server Business Intelligence Devlopment Studio - Reporting Project Error Messages: "An error occurred during client rendering." "An error has occurred during report processing." "Query execution failed for dataset 'DataSource...
what do the sql server icons mean?
I'm using SQL Server 2008 Management studio viewing a 2005 server and have just added 2 users. For some reason they both have slightly different icons and I'm not sure why. Anyone have a definitive list of the icons and their meaning or a link to microsoft's doc on it as I can't find anything anywhere. Thanks. ...
NHibernate.Spatial and Sql 2008 Geography type
hi there, i'm currently working on a project where i have to deal with sql server 2008 geography types. As big parts of the projects uses NHibernate as ORM i wonder how much work it will be to use/extend NHibernate.Spatial with this type (as far as i can see Nh Spatial only supports the geometry type yet). Btw. are there any other .net ...
New project sql server 2005 or 2008
I'll be starting a new project (asp.net) and I'll be using sql server express. Is there a reason NOT to use sql server 2008? P.S: I was considering Postgres 8.3 until I did some benchmarking and found out that sql server 2005 express is much faster for my needs (better integration I guess). ...
How to convert .NET DateTimeOffset ito Sql2008 DateTimeOffset
Hi folks, i'm not sure how to correctly format a .NET DateTimeOffset variable, as a string, for SqlServer 2008 to correct parse the value. currently, if i provide the default .ToString() value from a normal DateTimeOffset value, it errors. Here is a sample .ToString() value that errors (eg. Sql2008 doesn't like it): '25/12/2008 2:12:2...
VS2005 Configure "fallback" DLL
I'm trying to add SQL2008 support to a .NET 2.0 application. However, my unique constaint is that some users will still use SQL2005, and I don't want to require them to install the SQL2008 client components. The actual set of DLLs I need for SQL2008 are different than SQL2005. The code can remain the same. Botton line, I need a way i...
Using Full-Text Search in SQL Server 2008 across multiple tables, columns
I need to search across multiple columns from two tables in my database using Full-Text Search. The two tables in question have the relevant columns full-text indexed. The reason I'm opting for Full-text search: 1. To be able to search accented words easily (cafè) 2. To be able to rank according to word proximity, etc. 3. "Did you mean...
How to simplify this Sql query
The Table - Query has 2 columns (functionId, depFunctionId) I want all values that are either in functionid or in depfunctionid I am using this: select distinct depfunctionid from Query union select distinct functionid from Query How to do it better? ...
Restore SQL Server 2008 DB *to* SQL Server 2005
Got myself in a bit of a pickle here ... working on a CMS project, under the assumption that sql server 2008 was greenlighted as the db of choice. Well it wasn't, we now have to backport all of our content out SQL Server 2008 and into SQL Server 2005. A simple backup/restore procedure yields: "RESTORE HEADERONLY is terminating abnormal...
Why the Full-Text indexing option is greyed out?
I installed SQL Server 2008 Express with Advanced Services, but when I try to create a new database, the option Full-Text indexing is greyed out, I believe the full-text indexing has been installed, because I did a query as below: use [mydbname] select fulltextserviceproperty('isfulltextinstalled') This query returns 1, so I think it...
How to make this SSIS scenario more parallel
I have a million rows in a database table. For each row I have to run a custom exe, parse the output and update another database table How can I run process multiple rows in parallel? I now have a simple dataflow task ->GetData->Run Script (Run Process , Parse Output)->Store Data For 6000 rows it took 3 hours.Way too much. ...
What are the downsides of sqlserver 2008 (vs 2005)
I'm starting a new project and I'm considering using sqlserver 2008. I've had a lot of trouble getting teamsystem to work with it, and I'm wondering if sql server 2008 is widely used in productions environment yet. What whould you choose? How do you compare sqlserver 2005 and 2008? EDIT : I agree about the obvious and general tradeoff...
Tuning SQL Server 2008 for web applications
In one of the Stackoverflow podcasts, I remember Jeff Atwood saying that there was a configuration option in SQL Server 2008 which cuts down on locking, and was kind of an alternative to using "with (nolock)" in all your queries. Does anybody know how to enable the feature he was talking about, possibly even Jeff himself. I'm looking a...
Use smo to rename datafiles
How can I use SMO to rename the physical .mdf .ndf .ldf files. This article was helpful but I need to use C# SMO Objects. Using the SMO Server Object I can retrieve the database, then Get Access to the DataFile objects. Per this link. These have a Rename, however after rename, nothing changes. ...
Connection Pooling Not working in .Net SQL Server 2008
I'm testing out my application with the hopes of migrating to SQL Server 2008 (From 200). In the SQL Server profiler, I'm seeing Audit Login SQL:BatchStarting SELECT ..... SQL:BatchCompleted SELECT ..... Audit Logout for every single query that is being run. From what I can tell, this means t...
SQL Server 2008 Auto Generate Change Scripts Legacy Problem
We enable "Tools ==> Options ==> Designers ==> Table and Database Designers ==> Auto Generate Change Scripts" in our SQL Server Management Studio (SSMS). When changing our database schema, we save the script and, thanks to DB migration tools we've got installed on all the machines running our applications, we can synchronize the schema d...
How to make sure redundant data is deleted in a many-to-many relationship
Hi folks, I'm trying to make sure some data is auto-deleted when there's no more references using cascade deletes. I'll explain with a fake database based on Stack Overflow. I have a Post table. Each post has zero to many Tags. So it should look like: Post <-> PostTags <-> Tags eg. Post 1 has tags 'A', 'B', 'C' Post 2 has...
Can't add domain users to Reporting Services 2008
I have SSRS 2008 setup on the database server. The server is part of the domain. Reporting Services is running under NetworkService. When I try to add a domain user using the web interface (Site Settings --> Security --> New Role Assignment), the page posts back but the user is not in the list. The server's log file contains the foll...