Topics
Started by
Posts
Last post
Hi folks, SQL Server 2008 has enhanced INSERT..SELECT statement to allow minimal logging in certain…
10 replies
Hi i have a big problem here i have a list of person in my database each person have several entry …
2 replies
Tried this below with no luck I Wanted to use today's date if the parameter @enddate was greater t…
5 replies
From time to time, I need to test a users login with SQL, so I go to a registered servers propertie…
2 replies
Here is my query, select a.row,sum(CONVERT(decimal(11,0), a.value)) as total from (SELECT adc.row,a…
4 replies
Hello Everyone, What would be the best way to go about converting a part of this Filename from uppe…
3 replies
Hi I have a view which selects name and date say to make it short... each name can contain more tha…
6 replies
I need to count the number of days that a doctor works in a month. My data has the doc's name and a…
11 replies
I need to extract data from a sharepoint list, where the data is written within div tags. I got th…
7 replies
One of the Devs I work with "inherited" a DB that started life back in the '80s with ISAM and such.…
3 replies
I'm working in a rather locked down environment, and would rather avoid adding a DB if I can. I'm …
4 replies
Hi. I have just captured deadlock info into the error log using trace flag 1222. Can anybody help m…
5 replies
Hi Guys, I'm going to reorganize indexes with > 10%. Is there a need to update statistics after …
6 replies
Hi All, I'm working on database where a table contains an ID that is prefixed with a 2 letter ident…
2 replies
Hi apart of avg_fragmentation_in_percent in dm_db_index_physical_stats what other factor should be …
8 replies
Viewing 15 topics - 11,986 through 12,000 (of 30,222 total)
You must be logged in to create new topics.