Topics
Started by
Posts
Last post
Need help in logic for function.. The function should take the inputs year, translation_code and bu…
5 replies
Hello there, I am currently trying to tune a 3rd party system running on SQL2005 and came across so…
10 replies
Hi All. I'm having an odd occurence on oone of my prod servers. sometimes, with no pattern, the ser…
3 replies
Hi All, I'm going to end up in the loony bin if I don't get this right! Please see the SST below: D…
4 replies
Hi, I've tried the following query in SQL SERVER 2005, SQL Express and MACCESS. select * from …
7 replies
select sum(gam.DB_AMOUNT_01+gam.CR_AMOUNT_01) * curr_conv = case when gam.company in …
3 replies
Have an index on a table that keeps appearing in the sys.dm_db_missing_index_details DMV. The index…
1 replies
Hi All, I'm new to SQLSC and always willing to learn. I have my own way of tuning SQL server but I…
6 replies
Hi, In SQL Server 2000, if the data file size is 20 GB or more, is it better to split it into a num…
2 replies
Is there any fast and easy way to indentify index for 260 tables. i am given responsibility to inde…
2 replies
I dont know any thing about triggers, how they have to written, when they should be writtten, how d…
2 replies
I need the below query to return the actual_amt grouped by all the business units..I dont need the …
1 replies
Please help me in giving the suggestions for tuning the below query. The execution time is 1…
21 replies
I need your valuable suggestions on the following : What are the different aspects that I need to c…
10 replies
i want to update a date field whenever another field is updated. is this good? it will be triggered…
12 replies
Viewing 15 topics - 3,076 through 3,090 (of 3,249 total)
You must be logged in to create new topics.