|
More site info...
SQL Server Forums - www.sqlteam.com | Site profile
|
|
Site profile page for http://www.sqlteam.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.sqlteam.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.sqlteam.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on SQL Server Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
378
|
928
|
3,405
|
|
Post:
|
1,038
|
2,507
|
9,044
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for SQL Server Forums (http://www.sqlteam.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
SQL Server Forums posting activity graph:
|
|
http://www.sqlteam.com Alexa graph:
|
Top authors on SQL Server Forums during last week:
user's latest post:
Reg : Select more than one field...
Published (2009-10-31 09:14:00)
> quote: Originally posted by Pradip Hi Rajesh, Assume a table has 5 fields Field1, Field2, Field3, Field4, Field5 select case Field5 when 'A' then Field1, Field2 when 'B' then Field3, Field4 end it is possible like this select case Field5 when 'A' then Field1 when 'B' then Field3 end, case Field5 when 'A' then Field2 when 'B' then Field4 end end Is it ok ... pradipjain OP wanted...
user's latest post:
cannot connect to server
Published (2009-10-31 13:28:00)
> you need to install sql server, not just management studio download page: http://www.microsoft.com/downloadS/details.aspx?familyid=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en
user's latest post:
Format of date
Published (2009-10-31 11:21:00)
> Also converting the date when it isnt necessary will prevent use of any indexes on the date column. Always best to write your logic on the "right" side of the predicate. quote: Originally posted by madhivanan quote: Originally posted by Nageswar9 quote: Originally posted by Guestuser18 Thanks guys. I tried Nageswar9 suggestion but that didnt work. However webfred your suggestion did work. Cheers! tRY THIS select * from table...
user's latest post:
Log Shipping - Change Server Name
Published (2009-10-31 12:20:00)
> 1. Yes, but you'd have to update all of the log shipping tables in the msdb database to reflect the new name. 2. No, that's one of the reasons to use log shipping in SQL Server 2005 over database mirroring. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
user's latest post:
How to get percetage in query
Published (2009-10-31 01:05:00)
> The basic idea is to account to take only M & F genders in calculation and leave any other gender. iF theRe iS a wAy iN tHen theRe iS a wAy oUt..
user's latest post:
loop and update another table
Published (2009-10-31 18:54:00)
> Without seeing your code we have no idea how long your code might take to execute. But in general, 100,000 rows isn't particularly big, so with proper code and indexing your script should run without timing out. Jim Everyday I learn something that somebody else already knew
user's latest post:
Formatting date field
Published (2009-10-30 08:45:00)
> quote: is there a way that I can format the k.KeyEventEndDate as UK date format dd/mm/yyyy in the Select so that it does not interfere with the ORDER BY please? Why do you need to format the date, since KeyEventEndDate is a datetime data type, your query ORDER BY KeyEventEndDate should give you want you want. Is there anything with your query ? KH Time is always against us
user's latest post:
good music
Published (2009-10-30 13:44:00)
> Yes! Just wanted to make a joke. There is also a person Jack White (music producer) in germany and the music is more for a crooner who is loved by grandmas... No, you're never too old to Yak'n'Roll if you're too young to die.
user's latest post:
Formatting date field
Published (2009-10-30 09:13:00)
> quote: Originally posted by khtan quote: is there a way that I can format the k.KeyEventEndDate as UK date format dd/mm/yyyy in the Select so that it does not interfere with the ORDER BY please? Why do you need to format the date, since KeyEventEndDate is a datetime data type, your query ORDER BY KeyEventEndDate should give you want you want. Is there anything with your query ? KH Time is always against us Currently the script returns:...
|
|
|
Top 10 active forums on SQL Server Forums during last week:
|
|
Top 10 forums on SQL Server Forums:
New to SQL Server
- 45,811 posts
|
Transact-SQL (2000)
- 25,300 posts
|
SQL Server Development (2000)
- 24,256 posts
|
Transact-SQL (2005)
- 19,862 posts
|
SQL Server Administration (2005)
- 9,774 posts
|
The Yak Corral
- 8,060 posts
|
SQL Server Administration (2000)
- 7,280 posts
|
SSIS and Import/Export (2005)
- 4,135 posts
|
Analysis Server and Reporting Services (2005)
- 3,004 posts
|
Reporting Services Development
- 2,873 posts
|
|
|
|
|
Latest active threads on SQL Server Forums:
Started 1 week, 4 days ago (2009-10-30 01:25:00)
by russell
>
UPDATE t
SET col = x.id
FROM t2 t
JOIN t2 x
On t.id = x.id + 1
Started 1 week, 3 days ago (2009-10-31 18:54:00)
by jimf
>
Without seeing your code we have no idea how long your code might take to execute. But in general, 100,000 rows isn't particularly big, so with proper code and indexing your script should run without timing out. Jim Everyday I learn something that somebody else already knew
Started 1 week, 3 days ago (2009-10-31 18:49:00)
by jimf
>
select g.giftamount, g.giftid, g.gifteffdate ,[FirstGift] = CASE WHEN t1.FirstGift >= @begindate THEN 'Y' ELSE 'N' END from (select giftid,[FirstGift] = min(gifteffdate) from gifts group by giftid) t1 INNER JOIN cash.gifts g ON t1.giftid = g.giftid where g.gifttype = g and (g.gifteffdate >= @...
Started 1 week, 3 days ago (2009-10-31 17:29:00)
by Peso
>
SELECT CASE WHEN AVG(Col3) * 1.2 > MAX(Col3) THEN 1 WHEN AVG(Col3) * 0.8 < MIN(Col3) THEN 1 ELSE 0 END AS PriceFluctuation FROM Table1 WHERE Col1 >= DATEDIFF(DAY, 30, GETDATE()) -- 30 days ago AND Col1 < DATEDIFF(DAY, -1, GETDATE()) -- Tomorrow AND Col2 = 12345 -- ProductID N 56°04'39.26" E 12°55'05.63"
Started 1 week, 3 days ago (2009-10-31 15:42:00)
by afrika
>
You should use dbo for your objects and not "Develop_pricebook" Once you do, try it again select [dbo].[SplitWords] ('sdasdda, dfdsf')
Started 1 week, 3 days ago (2009-10-31 15:37:00)
by afrika
>
Yes, you can with sql server just simply use the IP,portnumber as the server instance. e.g 127.0.0.1, 2433 However you must configure it to accept remote connections.
Started 1 week, 4 days ago (2009-10-30 06:19:00)
by JCirocco
>
You may also check the version of IE. I have had issues in the past where IE8 would error out but IE7 would work fine. John It's a small world (but I wouldn't want to paint it)
Started 1 week, 3 days ago (2009-10-31 13:27:00)
by russell
>
declare @i int set @i=1 while(@i<=5) begin print 'a' @i++ set @i = @i + 1 end
Started 2 weeks, 5 days ago (2009-10-22 16:06:00)
by tkizer
>
http://weblogs.sqlteam.com/tarad/archive/2008/05/2 3/60609.aspx Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
Started 1 week, 3 days ago (2009-10-31 12:20:00)
by tkizer
>
1. Yes, but you'd have to update all of the log shipping tables in the msdb database to reflect the new name. 2. No, that's one of the reasons to use log shipping in SQL Server 2005 over database mirroring. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise ...
|
|
Hot threads for last week on SQL Server Forums:
No active threads for last week.
|
|
Size: 360 bytes
