I need to create a query that will sum the number of True(1) and False(0) into two separate columns from one bit field. I'm joining 3 tables and need it to be something like: Attribute | Class | Pass | Fail I will be grouping on Attribute and Class. ...
More of a curious question I can't seem to quickly find an definite answer to. In SQL Server 2008 is there a max limitation on the number of columns that are allowed in a view? From the MSDN article (below) I see that there is a limit of 4096 Columns per Select statement. Would this then be applied to a View? Example: CREATE VIEW [db...
How can I Select all columns from all tables from the DB, like: Select * From * in SQL Server 2008??? The table list it´s very very big, and have so many columns, is it possible to do it without writing the column names? Or maybe make a select that returns the name of the tables. ...
Hello, I have been trying really hard to install Sql Server 2008 sp1 along with VS 2008 sp1 on my Windows 7 machine. I tried every possible combination: install vs 2008 upgrade to sp1 then install sqlserver 2008 upgrade to sp1 using offline packet/upgrade automatically using windows update. However, I have nothing listed under Sql Ser...
SQL Server 2008 Linked Server and ad-hoc INSERTs cause a rapid memory leak which eventually causes the server to become non-responsive and ends with the following error: Msg 701, Level 17, State 123, Server BRECK-PC\SQLEXPRESS, Line 2 There is insufficient system memory in resource pool 'internal' to run this query. Location: q...
Storing daily stats for employees, and I want to store daily sales per employee (required for reporting, please don't argue the design! lol ) Table: EmployeeID DateStamp I figure I should make the datestamp a smalldatetime since I don't need that much accurancy. What should my query look like to see if there is an entry for the user...
I've just got to trying out Reporting Services and, although I'm a member of the local Administrators group in Windows, I can't do anything in Report Manager or by connecting to SSRS in SQL Management Studio. In Report Manager (it prompted me for my Windows credentials) I can see the Home page but I have no links to administer security e...
By default, when one tells SQL Server (currently using 2008) to Full-Text index a column, it treats characters such as "@" and "." as work-breakers, similarly to " ". I'd like to restrict the work-breaking characters to just be " ", so that "[email protected]" is treated as a single word. It appears that one can choose a "Langua...
I have a database server with few main databases, and few dozens of small ones. These small databases are kind of intermediary/staging databases for data import from various sources into main database. Data import is a daily task. They are all quite similar in structure as the implementation of these data imports are similar, so basical...
I have a full official copy of SS Managment Studio 2005 on my machine. I also have a copy of SS 2008 Express Management Studio (with SS 2008 Express loaded locally) on my machine. Is there a way to copy the tools (Profiler, Tuning advisor,etc) from SSMS 2005 to SSMS 2008 Express? I don't have permission to run those tools on the 2005 s...
I found: http://stackoverflow.com/questions/307636/how-do-you-setup-a-linked-server-to-an-oracle-database-on-sql-2000-2005 The DSN tested successfully but after using the stored procedures outlined in the article to create the linked server the 'open query' returned the following message: OLE DB provider "MSDASQL" for linked server "...
I have realized that my first question won't be answerable, since php can't deal with this format: http://stackoverflow.com/questions/1376103/how-to-convert-metafilepict-to-bitmapped-image-in-php, so I have a C# console application that will just load up the images, from either an MS SQL 2008 db, or Access 2007, and then save them to a d...
Hi I have SQL Server 2008 Developer Edition and I'm facing the following issues with the Reporting Services. When I open the Report Manager URL (I get it from the Reporting Services Configuration Manager) in a browser, it shows me a SQL Server Reporting Services page with a folder icon on top left and links with text 'Home', 'My subsc...
I'm in a situation where I'm going to deploy a small database to a server. It can easily run in the confines of SQL Server 2008 Express. However, I could also, if I wish, deploy this to SQL Server 2008 Enterprise. Assuming that Express has all the functionality and size that I need. Does it offer any speed advantage over Enterprise? i.e...
I'm working on my first significant Sql Reporting Services project and am having problems with paging. Most of the reports are already working. What is happening is that I"m getting different numbers and locations of page breaks between Web Reportviewer, PDF and Word documents. The word is the closest, but none of the three are really...
I have a local database with some data of type geography in it. I tried to use export wizard to copy the table to the target server, but get the error "Unknown coversion..". SSIS-conversion file: C:\Programme\Microsoft SQL Server\100\DTS\binn\DtwTypeConversion.xml. Is there an easy way to gert this data over to the target server? ...
Using the latest version of Subsonic (3.0.3) it doesnt appear to me that the geometry or geography data types are implemented as of October 09. My questions are: if and when is this support likely to be added? does anyone have a workaround to support operations on simple geography types at the DAL level? All I really care about at ...
I need to implement a service to search PDFs. Initially I started using SQL Server 2008 FTS, but soon realized that my PDFs would have to be stored in the DB itself. I was then pointed to Indexing Services as well as to the SQL 2008 FILESTREAM data type so that I can store PDFs in the file system. So how do these three (Indexing Servi...
I'm just doing some stat collection on multiple servers, and as a test I'm working with my machine (Machine A) and another machine (Machine B) on the local network. My Machine (A) is collecting all the information in the staging table from the other Machine (B). I have a sp that runs and dynamically creates something like this: exec (...
I have a MS SQL Query that is pulling data via from a remote server. The data that I'm pulling down needs to be filtered by a date that is determined at run time.. When I run the query like this: SELECT * FROM SERVER.Database.dbo.RemoteView WHERE EntryDate > '1/1/2009' then the filter is applied remotely... However, I don't actua...