-
During my last post try to query the actual size of the logfile, and today i'm going to share a script i found months ago at the microsoft site. I cant find the original link.... Notes: Be sure that you have a backup of your database so that if something goes wrong you have something to get back into...
-
Today I was preparing the DB for an implementation of one our module app, I brought along a soon to be production DB . The DB itself was not that big (5GB), however restoring it was taking alot of time. Normally I wouldn't worry about it, but I was on time constraints and the Establishment is working...
-
My App Crashed a few days ago. And the culprit, SQL Server LogFile. So i searched for ways to monitor my Transaction Log File and i found this use MYDB; SELECT sysfiles.size * 8/1024 FROM sysfiles WHERE NAME = 'MYDB_log' It will return the exact value which is shown on enterprise manager whenever you...
-
dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check...
-
Didn't you know that the following statement is now valid for Sql Server 2005 as criteria for a column with bit data type? SELECT * FROM Orders WHERE Processed = 'true' The engine is now intelligent enough to implicitly convert it to SELECT * FROM Orders WHERE Processed = 1 More readable, imo. Too bad...
-
(Originally from http://bassplayerdoc.spaces.live.com ) You'll probably see a lot of documentation on how to and why move the tempdb database on a different drive. One of them is a TechNet paper on Working with the tempdb in SQL Server 2005 . The tempdb database is a system database which is similar...
-
When I create an application, I always ask my client to give me a sample data for testing my application. Almost all my client give it to me on excel file. To copy the data from excel to SQL server, what I always do was to create a new DTS package then connect to the server then connect to excel file...
-
When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not...
Posted to
Rodel E. Dagumampan
by
rdagumampan
on
11-07-2006
Filed under:
Filed under: .NET, sql server , ASP.NET, usability and design, Development Process, how to, L10N, localization, scripts, stored procedures, user interface, sql, sequel server
-
I have been profiling my codes and my scripts trying to debug why I have lost lots of .50 cents every transaction, given I always use the decimal datatype when computing currency values. The business logic layer persists correct values and profiler shows result with its fractional part being passed to...
-
Maybe some of us are used into copying results of our query and pasting it to Excel for further analysis or reporting, but we are also used into SQL 2000 behaviour. With Sql Server 2005 Management Studio, you can copy and paste the query results including the headers. Just goto, Query -> Query Options...
-
Lots of developers write code in flash with the help of intellisense. But when coding t-sql is scripts, there is no built-in intellisense on query analyzer or SSMS. You will have to use a 3rd party tool to have intellisense on your query analyzer. But if you can't find 3rd party intellisense tool usefull...
-
Last time I blogged about SQL Server Inflectional Fulltext search filters out artiles like "the", "and", "in" etc. This has caused me headaches than fun when a lot of my test cases for searching failed or returns irrelevant results. I just found out thru my boss that I can turned this off by deleting...
-
I’ve been trying to familiarize myself lately with SQL CLR and I cant help but notice the similarity it has with MS Access and its VBA user-defined functions. Being a DBA working on both SQL Server and MS Access databases, Im quite fond of placing my business rules in the databases. With SQL Server,...
-
I was surprised tonight as I was testing the search engine of my project. It uses SQL Server Inflectional FullText search, but also supports boolean and simple search. Its good to see that it filter out these "and", "in" "of", "the", and other articles and returns 0 results when used as the only keyword...
-
An SqlParameter with ParameterDirection.Output has default size of 1 , this can be tricky if you use command.Parameters.AddWithValue(parameter, value) method in .NET 2.0. It was caught on my unit test when I want to retrieve the value of an output parameter, the returnErrorMessage variable must contain...