I have an existing multi-instance SQL 2008 cluster, and I'm trying to add Analysis Services to an existing instance. I start the installation, pick "Add features", configure SSAS, and then on the final pre-installation check, I fail the "Existing clustered or cluster-prepared instance" check. Of course I'd fail this check - I'm trying to...
I get an exception when I "Select * from deleted" in a clr trigger in SQL Server 2008. Is there anyway to be able to access xml/text columns from the deleted and inserted tables in a trigger? ...
For SQL Server 2008 Developer Edition on Vista 64 bit: I tried copying a database using a Vista admin account using the attach/detach method and it failed due to a file permission error so I gave the user that sql services are running as write and modify to the directory. The copy didn't work. I then gave it full control. The copy wo...
Please provide guidelines on when to use DSV's as opposed to database views. Any performance issue using one vs. the other? Environment: SQL Server 2008 ...
Is there a way I can get a scripting of all tables, procs, and other objects from a database? I know there's an option to script the database but it only gave me some sort of top level script, certainly not a script to create all tables, procs, udfs, .etc. ...
I need to implement a tool that runs programs from SQL Server database when a DB record matches some condition. Is there a way to do it? ...
hi there, today i ran into a possible size limitation of geography type Linestrings within Sql Server 2008. when i create a Linestring with STGeomFromText that contains 567 points containing Long,Lat and Z coordinates, everything works fine. However, if i add one more point to the linestring i get an ArgumentException 24200: The speci...
I have just noticed that Sql Profiler 2008 is not hiding trace outputs that include sp params called password. In 2005 it used to give me a message saying "The text has been replaced with this comment for security reasons". Has they removed this security feature? ...
We recently upgraded a database server from SQL 2005 to SQL 2008 64 bit. CPU utilization is oftentimes running at 100% on all four processors now (this never happended on the SQL 2005 server). When I run sp_lock I see a number of processes waiting on a resource called [ENCRYPTION_SCAN]. I am not using any SQL 2008 encryption features. Do...
Hi folks, I have a table (ie. ReportData) which contains some calculated data -> eg. classroom average scores, number of students, avg grade point, etc. etc. lots of report like data. Works great. Now, in some of my other tables (eg. the ClassRoom table) if i change some data in there, I need to update the ReportData table. So I thou...
Question: Is it possible to stop SSMS from monitoring the service status of registered servers? Details: SSMS 2008 monitors the service status of every registered server. From what I have seen it seems to reach out to every registered server every minute or so to check it's status, in my case that is over 100 servers. This process has...
Hello, I was wondering if SQL Server is actually utilizing its fulltext index on searches that can be in the middle of text (such as LIKE %searchKeyword%)? I forgot where I read it, but I did read somewhere that the fulltext index would only be utilized when it is used in a "StartsWith" manner (searchKeyword%) where you search for a LIK...
Usually throughout development of a project I will deploy frequently, just to make sure I wont have any problems in production. Also, throughout development, I find myself changing the database's schema. How can I easily update the database in production? I have been dropping the old database and reattaching the new one. Is there a fa...
I am managing a data warehouse. I have several dimension tables most of which are type-2 and some are type-1. I was able to figure out how to use MERGE to maintain my type-1 dimension tables. I am stumped on how to do the type-2 dimension tables. How do I do both, the update to the EndDate and an insert using the MERGE Command? ...
Can someone tell me what the most efficient way to transfer SQL Jobs from SQL Server 2005 to sql 2008. I'm currently upgrading my sql servers to 2008. Thanks! ...
Hello, This is the situation. table a cola1 cola2 table b colb1 colb2 colb3 colb4 colb5 table c colc1 colc2 colc3 for every value of cola2 = colb1 and colb4 = colc12 , fetch colb2 for every value of cola2 = colb1 and colb5 = colc3, fetch colb3 calculate (colb3- colb2) * size * factor1 for every cola2. Calculate SUM((colb3- colb2) * ...
I have created a transformation component, and basically it accepts data from a source, and will do very transformations before it can save the information in a database. But, I want to map between the source columns and the database columns that are called up from my transformation component. I would like it to look like the mapping i...
Hi, I am trying to query out the attribute values from the xml file attached below. Specifically, I am trying to get the Name, SqlDbType etc. attribute values that are in the "Column" Element Node under"ColumnNullRatioProfile" Node. The xml output file comes as a part of the SQL Server 2008 SSIS DataProfiler Task. My goal is to use Pow...
Hi folks, I'm having trouble trying to rank each of our students, by the homegroup they are in. Example fake data. HomeGroup 1. Team RED 2. Team BLUE 3. Team Skeet 4. Team GREEN Students 1. John, Score - 34, Team RED 2. Jill, Score - 87.3, Team RED 3. Fred, Score - 41, Team GREEN 4. Jane, Score 93, Team BLUE ... etc. My output is ...
I about to pull my hair out if i have to re install everything again! I've installed Visual Studio 2008 SP1 then TFS and when I try to install SQL Server 2008 there is an error message telling me to install the SP1 of Visual Studio. After a quick look on Google and SO, I've found the mysterious problem of TFS not being tagged as SP1 w...