Viewing 15 posts - 346 through 360 (of 444 total)
You can simply use SET QUERY_GOVERNOR_COST_LIMIT in the login trigger. You can check the currenttime of the server in the trigger and if it falls in your peak hours, set...
August 5, 2008 at 3:32 am
Try Using INFORMATION_SCHEMA.TABLES
It contains the tablename and the schema.
It also contains the list of views in it with TABLE_TYPE = 'VIEW'
Atif Sheikh
August 5, 2008 at 3:06 am
I havent tried to install SQL 2008 till now. Waiting for the Full and Final release. Would definitely take help from the video while installation.
Nice work...
Atif Sheikh
August 5, 2008 at 1:27 am
eerkan... your solution misses one record
Try again...:D
Atif Sheikh
August 5, 2008 at 1:24 am
GREAT ARTICLE...
Alot of learning points in it...
My First thought, I would have gone for cursors to solve the issue. Secondly, I would certainly NOT go for the conversions as...
August 5, 2008 at 1:21 am
If the the requirement is that you want top 1 record against each Duplicate ID in your stage table, than the solution above should work. Otherwise, can you please post...
August 4, 2008 at 4:54 am
Also, working at home also depends on the policy oif the company you are working in. If it is a bank or even a Software development firm, the don't and...
August 4, 2008 at 3:09 am
I drive for 15 minutes to get to my office. Working at home can be benificial if you dont have kids OR the are school going. Mine are too young...
August 4, 2008 at 3:04 am
In our application, we send the data from PDA to the Server (Gateway in our case) as soon as it reaches the PDA. PDA also keeps the track of the...
August 4, 2008 at 3:00 am
You are right Grant. I was just making clear that IDENTITY column may have duplicate values IFF the IDENTITY_INSERT is set to ON while inserting a record OR if RESEED...
August 4, 2008 at 12:47 am
read the following article for your answers...
http://support.microsoft.com/kb/322112
I think it will give you a better understanding...
Atif Sheikh
August 4, 2008 at 12:12 am
Ok.. Found the tool to do so. Try SqlAssist. It is possible in it...
Atif Sheikh
August 4, 2008 at 12:06 am
I wonder why the article is dated 2001/07/25. Is it that old...? Any ways, somewhat information for me (at least) about Datatect 1.6. Will use it to see what it...
August 3, 2008 at 9:57 pm
It will be very convinient if you post the sample data
Atif SHeikh
August 1, 2008 at 5:58 am
I simply created a table with a float column and inserted the records in it as
INSERT INTO Tab2 (ff)
SELECT (0.003 / 100000) FROM Tally a ,Tally...
August 1, 2008 at 5:51 am
Viewing 15 posts - 346 through 360 (of 444 total)