Books online has very good explanation about DBCC shrinkfile and effects of truncate options. Check this link...
Try this:DECLARE @d1 DATETIME,@div SMALLINT set @d1=getdate()set @div=(datepart(n,@d1))%10select CASE WHEN @div <=5 THEN DATEADD(n,-@div,@d1)WHEN...
I have found below lines from BOL which could help. If the query uses cursors, determine if the cursor query could be written using either a more...
Could you please elaborate more on what do you mean by auto locking and storing commands. Do you mean you want customised auditing/logging solution....
Hi, In Parameter mapping you need to set parameter name which is required by the procedure. Click on parameter mapping and select user variable which...
You can add a sql task in the package to perform conditional purging of data. you can store the datetime of last purge in a table and when the time...
Are you using CONVERT function to convert datatype to NVARCHAR anywhere as part of your code?
Try adding the below statement in your query at the end and check the result. WHERE x.work_atty IS NULL
You can write a query joining both the tables using LEFT JOIN on the columns which you want to join. Then in the where clause add the condition to...
Have a look at this KB which is based on the same issue. http://support.microsoft.com/kb/910070/en-us
Hi, If your weeknumber is based on week of the year then consider this select 'WW'+convert(varchar(10),datepart(wk,getdate())) UPDATE ABC SET...
Hi, Below mentioned technical articles are worth reading for multilingual support in sql server 2000....
I feel it would be better if you handle loading image into database from the front end using byte array. Check this:...
HI, Read about storage option in Analysis server in more detail from BOL. If you are dealing with 2005, then read about Automatic MOLAP which will...
If you specify ORDER BY then SQL SERVER guarantees a sorted result. Even if you create a view with inline ORDER BY clause and then if you query that...
One way could be to create intermediate measure group holding relation between product dimension and your key column from fact table. After this in...
Hi, I feel it would be better if you create a stored procedure to read SQL statement from table and then execute the same in the stored procedure...
Hi, There are various ways by which you can insert same data into more than one place. 1>you can create a SSIS package or use import export wizard...
Update AverageEngTime set Sat_Night =(SELECT AVG(Sat_Night) FROM Weekly) where Shifts = 'Average'
Have you installed the latest SQL Server 2000 service pack
Separate names with a comma.
