Fact And Dimension from the One Table.
Hi i m new to SSAS 2005/08. I want to create Cube from 1 table , Stored in OLTP Database. Table containg billions of records. how to select dimension and Fact from this alone table. Please help me. ...
sql-server-2005
Update MySQL database from SQL Server in different domain
I am SQL Server developer and the current assignment is little different than what I have done in past. I found Stack Overflow very promising for my problem. I am working on the SQL Server 2005 database for the internal application for my client and the client also got the public facing web application with MySQL database. I do not have ...
How can I find Replication Bytes Per second in SQL 2005?
Is there an easy way to get a bytes per second measurement for replication? I am trying to get a mesuarment for some networking people. Thanks ...
SQL Exam - estimating table size problem
I'm preparing to the SQL Server exam (70-431). I have the book from Sybex "SQL Server 2005 - Implementation and Maintenance". I'm little confused about estimating a size of a table. In the 2nd chapter there is explained how to do this: Count the row size from the formula: Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap +...
How do I identify a blank uniqueidentifier in SQL Server 2005?
Hello I'm getting a uniqueidentifier into a Stored Procedure that looks like this "00000000-0000-0000-0000-000000000000". This seems like a simple thing, but how can identify that this is a blank uniqueidentifier? If I get a value like this "DDB72E0C-FC43-4C34-A924-741445153021" I want to do X If I get a value like this "00000000-0...
How can I rewrite this statement?
I have declared a variable @date SELECT @date = CASE WHEN MAX(dt) IS NULL THEN '31/12/2009' ELSE MAX(dt) + 1 END FROM mytab A code snippet where I am using the local variable CASE WHEN MAX(DateValue)= @date THEN NULL ELSE CONVERT(varchar(10), CONVERT(datetime, MAX(DateValue)), 103) END AS newdt I don't wa...
Install order for SQL Server 2005 developer and VS 2008 on Windows 7
I always seem to battle with this so on my new Windows 7 dev PC build, I thought I'd try and get it right! Do you install VS 2008 first and then SQL Server 2005 developer or the other way around? And for either way, are there any special options/settings that have to be enabled/disabled? I've just take an Acronis image of my PC, config...
Custom sort-order with SQL-Server and .NET Entity-Framework
Hello! I have a table I store contacts and their phones. Contact: ContactId (int, PK), FirstName (varchar), LastName (varchar) Phone: PhoneId (int, PK), ContactId(int FK), Number (varchar), SortOrder (tinyint) I want that under each contact, the user should be able to maintain the priority of the phones, meaning that the SortOrder co...
SQL Server 2005 becomes blocked with no locked or locking processes
We have a database (let's call it database A) which becomes unusable every some days and we have to restart it. When I say unusable means all applications using it just block there waiting for the database to respond but it never does. By luck it was noticed that executing a SELECT statement against a specific table using the SQL Server...
ASP.NET GridView throws: The version of SQL Server in use does not support datatype 'date'.
How to deal with a server that doesn't support 'date'? Sorry for such a vague question. Please let me know what addtional details I should add. Thanks. Here's the error: Server Error in '/' Application. The version of SQL Server in use does not support datatype 'date'. Description: An unhandled exception occurred during the execution...
How to make computed column not nullable?
So far I've been using ISNULL(dbo.fn_GetPrice(ItemId), 0) to make it not nullable (rather call it default-valued, but whatever). Is this the right way? ...
are there any special conditions with '*' character in full text search
i am using sql server 2005 i have a stored procedure which searches database with containstable method the problem is when i search some prefix with '*' character i can't see the records which have full word just records with only prefixes. for example i search 'some' then set my variable to 'some*' and i have 'some' and 'something' reco...
Subtract all values from data
Table data look like this id val 1 4 2 2 3 1 I want result of subtract valu of val field in one sql statement. like it should be like 4-2-1 = 1 if order by id asc, 1-2-4 = -5 if order by id desc. ...
Connection pooling in .Net Sql Provider - when connection is closed
Hi, I just wonder after what duration .Net Sql Provider will close connection which is in pool? Thanks, Pawel ...
database publishing wizard connection timeout error
I am getting the following error when using the database publishing wizard to publish some mojoportal sql scripts from a sql express database on my local box: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size w...
sql stored procedure that selects from array/list/xml input parameter
Hi All, I’m looking for idea’s/solution to the following problem. Require a stored procedure that accepts a single parameter (array, list, collection, xml, etc…). For each item in the array/list/collection/xml it will execute a query like this: Select * from <some table> t Where t.Name = Parameter.Name and t.datetime = Parameter.dat...
Can I change execution context in a SP from OWNER to CALLER? [SQL Server 2005]
Is it possible to change execution context to CALLER in a stored procedure, which is created with EXECUTE AS OWNER? Here is what I mean with a simplified example: There are several logins and databases in a server instance. Assume that everybody has a table named *current_work* in his own database, but nobody can access to no other's ta...
Check for arithmetic overflows in computed columns?
In our application we're going to be allowing users to type in arithmetic expressions (+ - * /) using other database columns for numbers, which would then be parsed by the application and written into the database as a computed column. However there are problems that arise with allowing users to create expressions that could cause excep...
Need help with SQL aggregation query
What is the most straightforward approach to producing a data set that can be used in a SQL Server Reporting Services report to display the following: SalesPerson # Sales # Gross Profit John Doe 100 $140,000 $25,000 Everyone Else (Avg.) 1200 $2,000,000 $250,000 Jane Smith ...
Most Executed Stored Procedure?
We created so many inefficient stored procedure in our application, we always postpone to make it more efficient until we have serious problem with database performance. Now, I am thinking to fix it one by one order by most often executed stored procedure. What is the best way to figure out which stored procedure is the most executed? ...