|
More site info...
Simple-Talk - Forums - www.simple-talk.com | Site profile
|
|
Site profile page for http://www.simple-talk.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.simple-talk.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.simple-talk.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 Simple-Talk - Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
13
|
48
|
117
|
|
Post:
|
14
|
55
|
136
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Simple-Talk - Forums (http://www.simple-talk.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.
|
|
|
|
|
Simple-Talk - Forums posting activity graph:
|
|
http://www.simple-talk.com Alexa graph:
|
Top authors on Simple-Talk - Forums during last week:
user's latest post:
JDBC Driver with JRE
Published (2009-12-24 07:39:18)
JDBC Driver version 3.0.16 suports both give it a try good luck
user's latest post:
Problem with identity column
Published (2009-12-29 00:19:29)
Yes.I also set reseed identity value as negative value.This is workaround only.Because of negative value has also some range value.Now i have enough time to change int to bigint type for all tables. Thanks for your reply. -Selvaraj
user's latest post:
MDF Database Attachment Error
Published (2009-12-23 09:31:09)
I have heard about similar application for corrupted file mdf mssql 2003 recovery. hope it helps
user's latest post:
RS Config Mgr - Database Version
Published (2009-12-30 22:06:52)
got this fixed. just deleted the ReportServer database. Tried to create the same ReportServer database but it croupt. Needed to created a new db name and redeploy all reports.
user's latest post:
partition a big table
Published (2009-12-30 08:14:00)
hi all, In our sql server 2005 we have a table with about 30 millions records and it grows up day by day. one million records are inserted for a day. i wonder what is best practice for partitioning a table? is it a good idead to use Partitioned Tables ? or can i use anything else instead of Partitioned Tables ? thanx in advance
user's latest post:
Queue activation Procedure failed
Published (2009-12-23 08:36:17)
Hi All, I have a service broker application with a single Queue which act as both source&target and a service associated with it. I am facing a strange problem. Messages placing a queue but activation procedure is not calling at all. I followed the similar procedure same as http://rusanu.com/2009/08/05/asynchronous-procedure-execution/ if i check AsyncExecResults table it contains token&submit_time column values only remaining...
user's latest post:
SQL Back end Front end ???
Published (2009-12-24 18:41:07)
I need some clarification. SQL Server is the back end in most cases. If you want users to enter data into forms you have to create a form in another programming language. In this forums opionion what are some of the best and most popular languages used to create that form? Thanks, Tina
user's latest post:
Problem with identity column
Published (2009-12-28 14:11:00)
I haven't tried this, but how about setting your identity key's increment value to negative one (-1). In essence youâre assigning a negative value to your primary key and youâre just decrementing instead of incrementing without having a need to change the field type. It may be worth a try, but this is not a permanent fix. Hopefully this will buy you enough time to update...
user's latest post:
partition a big table
Published (2009-12-30 16:46:00)
I think that it is not bad idea to use the partition table, sure that you need to organized the data in many data files and partitioning them in one logic according your data. Till you are in SQL Server 2005 environment you should create partition function and partition scheme and specifying range values, everything manually, in SQL Server 2008 you can do it with wizard and I think much easy than in SQL Server 2005. Anyway I prefer the...
|
|
|
Top 10 active forums on Simple-Talk - Forums during last week:
|
|
Top 10 forums on Simple-Talk - Forums:
|
|
|
|
Latest active threads on Simple-Talk - Forums:
Started 3 days, 1 hour ago (2009-12-30 22:06:52)
by bvolk
got this fixed. just deleted the ReportServer database. Tried to create the same ReportServer database but it croupt. Needed to created a new db name and redeploy all reports.
Started 3 days, 7 hours ago (2009-12-30 16:46:00)
by Dugi
I think that it is not bad idea to use the partition table, sure that you need to organized the data in many data files and partitioning them in one logic according your data. Till you are in SQL Server 2005 environment you should create partition function and partition scheme and specifying range values, everything manually, in SQL Server 2008 you can do it with wizard and I think much easy ...
Started 3 days, 18 hours ago (2009-12-30 05:57:00)
by divya
I have given the code for a single table.. you can add the other table
declare @site table(siteid int,sitetypeid int,powertypeid int)
declare @sitetyperen table(renewableid int,sitetypeid int,siteid int)
declare @sitetype table(sitetypeid int,sitetype varchar(100))
insert into @site
select 1,10,3
union all
select 2,20,1
union all
select 3,30,2
union all
select 4, 30,1
insert into ...
Started 2 weeks, 4 days ago (2009-12-15 09:03:00)
by Arles
Have you considered changing the type of your primary key to BIGINT?
Started 1 week, 2 days ago (2009-12-24 07:39:18)
by wayne.zjw
JDBC Driver version 3.0.16 suports both
give it a try
good luck
Started 5 days, 23 hours ago (2009-12-28 00:37:40)
by selvaraj
It is possible to grant execute permission to either one by one procedure or all procedure. Example for one by one, GRANT EXECUTE ON procedurename1 to username; GRANT EXECUTE ON procedurename2 to username; GRANT EXECUTE ON procedurename3 to username; ............ Example for all procedure, GRANT EXECUTE ANY PROCEDURE TO username; - Selvaraj
Started 1 week, 5 days ago (2009-12-21 04:24:00)
by selvaraj
Can you provide the error message ? that will useful for finding the problem. -Selvaraj
Started 4 months, 2 weeks ago (2009-08-21 05:39:00)
by Phil Factor
It is difficult for anyone to answer this one because we have to puzzle out what you did to get to this point and what your windows event log is saying. Have you had any warning of a corruption in the database previous to this? If you are attaching a database file, have you already tried attaching it without the log file? What error does this give (please include all info) USE [master] ...
|
|
Hot threads for last week on Simple-Talk - Forums:
Started 5 days, 23 hours ago (2009-12-28 00:37:40)
by selvaraj
It is possible to grant execute permission to either one by one procedure or all procedure. Example for one by one, GRANT EXECUTE ON procedurename1 to username; GRANT EXECUTE ON procedurename2 to username; GRANT EXECUTE ON procedurename3 to username; ............ Example for all procedure, GRANT EXECUTE ANY PROCEDURE TO username; - Selvaraj
Started 2 weeks, 4 days ago (2009-12-15 09:03:00)
by Arles
Have you considered changing the type of your primary key to BIGINT?
Started 3 days, 1 hour ago (2009-12-30 22:06:52)
by bvolk
got this fixed. just deleted the ReportServer database. Tried to create the same ReportServer database but it croupt. Needed to created a new db name and redeploy all reports.
Started 3 days, 7 hours ago (2009-12-30 16:46:00)
by Dugi
I think that it is not bad idea to use the partition table, sure that you need to organized the data in many data files and partitioning them in one logic according your data. Till you are in SQL Server 2005 environment you should create partition function and partition scheme and specifying range values, everything manually, in SQL Server 2008 you can do it with wizard and I think much easy ...
Started 1 week, 2 days ago (2009-12-24 07:39:18)
by wayne.zjw
JDBC Driver version 3.0.16 suports both
give it a try
good luck
Started 3 days, 18 hours ago (2009-12-30 05:57:00)
by divya
I have given the code for a single table.. you can add the other table
declare @site table(siteid int,sitetypeid int,powertypeid int)
declare @sitetyperen table(renewableid int,sitetypeid int,siteid int)
declare @sitetype table(sitetypeid int,sitetype varchar(100))
insert into @site
select 1,10,3
union all
select 2,20,1
union all
select 3,30,2
union all
select 4, 30,1
insert into ...
|
|
Size: 175 bytes
