Analysis Services Performance 102 cubes does sound a little extreme. I need to ask, are you running 2005 or 2000 Also are you running anything else on the box SSRS
B. Tag: SQL Server 2005 Express Edition
70-431 (MCTS - SQL 2005) If you're looking for brain dumps this is not the site to get those answers. The 70-431 exam is a 200-level "how-to" exam on all the nuts and bolts of SQL Server 2005. There are free eLearning classes available on the Microsoft web site which will help you with the content information for the test, as well as a number of excellent books hitting the market about now.
I believe you'll get about 40 questions on the test, though it may be higher than that, and you'll get about 2 1/2 hours to answer them.
Go to www.microsoft.com/sql and click on Learning and you'll find out all you need to know to prepare for the test.
Good luck. Tag: SQL Server 2005 Express Edition
How do I not show a field if the field contains nothing? To account for a null or empty string in address2...
=RTrim(Fields!FirstName.Value) & " " & Fields!LastName.Value & vbCrLF &
Fields!Address1.Value & vbCrLF & IIF(Fields!Address2.Value Is Nothing Or Fields!Address2.Value = "", "", Fields!Address2.Value & vbCrLF) &
RTrim(Fields!City.Value) & ", " & Fields!State.Value & " " & Fields!ZipCode.Value Tag: SQL Server 2005 Express Edition
Non-queried Parameters and what happens if you just enter "001,002,003" as the value assuming the datatype is string Tag: SQL Server 2005 Express Edition
MS SQL installation error Was there a work-a-round for this I have found only two references to this error, both without resolution :-(
Currently getting same error on Windows 2003 64Bit - SQL2005 install also on cluster...
Regards
Rod Tag: SQL Server 2005 Express Edition
Display DB Table in ASP What about:
http://www.stardeveloper.com/articles/display.html article=2002061201&page=1 Jens K. Suessmeyer
--- http://www.sqlserver2005.de --- Tag: SQL Server 2005 Express Edition
SSIS Capacity If your data have to be transformed, cleaned and this action of uploading is periodically i should use SSIS in any case.
If you have a single file with 100 gb size i shouldn't use SSIS for that.
if you have 100 gb of data in a file that can be bulk inserted in some columns of a table i should use bcp (before change recovery model in "Bulk logged" and after revert to initial recovery model of db) or T-SQL bulk insert command if yor data have not to be cleaned or transformed and in plus there is the effort to build a SSIS package. Tag: SQL Server 2005 Express Edition
Transaction log file disappearing without reason i don't think this is a problem of SQL Server. You cannot delete a log file of database which is in use from SQL Server. It may be the problem from OS or any other application.
Madhu Tag: SQL Server 2005 Express Edition
Stored Proc NOT using Index? This could be as a result of parameter sniffing, SQL Servers attempt to provide an optimum query plan based upon values of parameters. Sometimes, this is not the "best" overall plan due to atypical values being passed in and therefore the cached plan for the stored procedure is less than optimal for the majority of queries causing poor performance. The code executes fast in SSMS as a new plan is generated on the fly.
Read more here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
HTH! Tag: SQL Server 2005 Express Edition
Sample code to importing data from ODBC Qiuwei wrote:
Hi, there; I try to import data from ODBC using C# programmatically. Is there any sample code we can have a look. Like how to read schema from ODBC source table and then create source column... Thanks
Sounds like you're in the wrong forum. If you are writing a dotnet app then try the dotnet forums.
If you are using SSIS then I'm not really understanding why you're writing C# code. Are you trying to build a SSIS package programatically using the SSIS API
-Jamie Tag: SQL Server 2005 Express Edition
Add column with fixed number of values (text) to the select statement I found on the net something to start with
Adding Columns in SQL SELECT statements by Andy Kramek http://weblogs.foxite.com/andykramek/archive/2005/09/18/921.aspx
SELECT *, CAST( 0 AS INT) AS newint FROM sample
but it just add a column with value 0 to the set of results. Tag: SQL Server 2005 Express Edition
Editing Input Data in Script Component Why don't you use a derived column instead Should be a better performing option anyway. [COLNAME] == " " "" : [COLNAME] Tag: SQL Server 2005 Express Edition
SQL Server Management Studio Express won't open but appears in task-bar If you have any databases that you care about, you can do a few things to rescue those and then manually uninstall and reinstall. If you don't care about the databases, just follow step number four in the first option. It may be that the system is OK and you're just having problems with the GUI loading, so try this first:
1. Check to make sure the SQL Server Services are running.
2. Open the sqlcmd command at the operating system and back up your databases (Look in Books Online for the "backup database" command syntax).
3. Put the backups in a safe location so that you can restore them later.
4. Uninstall SQL Server manually following this process: http://support.microsoft.com/kb/909967
5. And then reinstall SQL Server.
6. If this all works, you should be able to restore the database back to your system. You can read more about that in Books Online under the "restore database" command syntax.
The next method of rescue might not save the databases if the system shut down incorrectly.
1. Ensure that the SQL Server services are shut down.
2. Locate the MDF files that belong to your database and copy them to a safe place.
3. Uninstall SQL Server manually following this process: http://support.microsoft.com/kb/909967
4. And then reinstall SQL Server Express.
5. If this all works, you should be able to "attach" the database back to your system. You can read more about that in Books Online under "attaching databases".
It should be noted that this is a really strange event, and a simple crash wouldn't normally bonk the system like that. My suspicion is that something happened in the registry on the unclean shutdown.
Buck Woody Tag: SQL Server 2005 Express Edition
Pass parameter to SSIS I would add a SSIS variable to the package to hold the parameter you want to pass, let's say @PassedParam.
I would assign the parameter value via dtexec command line; using the SET option.
I would put the SQL Statement into another SSIS variable that is based in a expression (EvaluateAsExpression property in the variable equal to TRUE). That expression would use look at the @PassedParam variable.
Let me know if this make sense... Tag: SQL Server 2005 Express Edition
Partitioned Tables and Parameters Hi Eric,
I guess you need to try creating an index.
create clustered index idx_part on tblPartitionTest ( PartitionKey )
go
regards
Jag Tag: SQL Server 2005 Express Edition
Granting Permissions using SQL 2005 Schema... They would need alter schema to drop tables in the schema.
GRANT ALTER ON SCHEMA::[Sandbox] TO [Sandbox Users]
-Sue Tag: SQL Server 2005 Express Edition
Returning a value that has the smallest number of instances in a table Something like this may work:
Code Block
SELECT *
FROM ( SELECT TOP 1 AssessorRegistrationNo , COUNT (*) AS NoAssignments
FROM MyTable
WHERE Marked = 0 AND DateAssigned IS NOT NULL
GROUP BY AssessorRegistrationNo
ORDER BY COUNT (*) DESC ) AS Tbl
HTH! Tag: SQL Server 2005 Express Edition
Error Casting String to Date I did something similar in thsi post http://rafael-salas.blogspot.com/2007/02/ssis-loop-through-files-in-date-range.html See if you can get any help from there. Tag: SQL Server 2005 Express Edition
Reporting Services Matrix Reports Repeating row labels Is it possible to repeat the row labels for matrix reports where there are multiple groups. So if the matrix report rows are department,division,employee then have all three labels show up on each row not just at the breaks. Cannot seem to find a way to do this. thanks Tag: SQL Server 2005 Express Edition
COUNT and COUNT_BIG are too slowly, what to do?! The reason for using count_big() is that you expect your returned count value exceeds INT limit. If your table is not that large there isn't a need for count_big(). The perf between using count() vs count_big() on this small table should be nearly identical. The first query should take the longest which is natural and expected. Later queries benefit from the first because the data has cached. It's absolutely wrong to correlate 1 second for 100K and 10 seconds for 1M. It does not work in such linear fashion. The length it takes to compute the count is all depending on the system at that time. If the system is busy and there is no cache, it can take forever. Tag: SQL Server 2005 Express Edition
SERVER MESSAGES to textbox What server messages do you mean Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: SQL Server 2005 Express Edition
What is the easy way to do this?. You could use a computed column, see below.
Chris
Code Block
IF OBJECT_ID ( 'tempdb..#Test' ) IS NOT NULL DROP TABLE #Test GO CREATE TABLE #Test ( [TestID] INT IDENTITY ( 1 , 1 ), [enddt] DATETIME , [status] AS CAST (( CASE WHEN enddt <= GETDATE () THEN 'live' ELSE 'expired' END ) AS VARCHAR ( 20 )) ) GO INSERT INTO #Test ( enddt ) SELECT '20071210' UNION SELECT '20071028' SELECT * FROM #Test GO IF OBJECT_ID ( 'tempdb..#Test' ) IS NOT NULL DROP TABLE #Test GO
/*
TestID enddt status
1 2007-12-10 00:00:00.000 expired 2 2007-10-28 00:00:00.000 live */ Tag: SQL Server 2005 Express Edition
SQL Server 2005 Log Shipping Error 14262 Hi Jonathan
I need some more detail regarding the error you are seeing. Can you let me know exactly which "Log Shipping procedure" you are running and where you are seeing the error Are you using the stored procedures to configure log shipping or SSMS
Thanks, Mark Tag: SQL Server 2005 Express Edition
Is it possible to know whether report is still executing in report viewer? (Web Forms) YOu can use the asynchronous methods for rendering the report, if the report did not raise the event of finishing you can be sure that the report is already running.
Jens K . Suessmeyer .
---
http :// www . sqlserver2005 . de
--- Tag: SQL Server 2005 Express Edition
Help using copy database wizard The online or local help for Copy Database Wizard goes into more detail, but I can give a couple of possible tips:
1. Remote job event logs or files will show up on the destination server machine not the machine running CDW (if they are different machines). Look in the WIndows event log on that machine, or in the file system there if you redirected error output logging to a file.
2. Location of Source Database Files refers to the path to the .mdf/.ldf files of the source datatase as seen from the destination machine . Usually in the form of a net share path of the form \\machine\share\ ... which you share out to get at the data files for the database you want to copy. CDW will invoke a job on the destination machine under either your domain account or some proxy account (depending on how you indicate it) which will use the file share path you gave it in the wizard to try to access the source machine's database data and log files. Share security permissions are also material just like you were trying to map the source machine share and copy the files yourself using Windows Explorer on the destination machine.
Hope that helps, and the online or local help can give some more details on what I summarized above. Tag: SQL Server 2005 Express Edition