Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

SQL Server Forum - www.sqlmonster.com | Site profile

Site profile page for http://www.sqlmonster.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://www.sqlmonster.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.sqlmonster.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.

Title: SQL Server Forum - http://www.sqlmonster.com SQL Server Forum
Url: http://www.sqlmonster.com
Users activity: 2 posts per thread
site activity: 416 active threads during last week
Site rank: 1,819 (go to rank page)
Domain info for: sqlmonster.com
 

Posting activity table on SQL Server Forum:

  Week Month 3 Months
Threads: 416 1,402 4,386
Post: 728 2,736 9,524
 

Authority Badge:

SQL Server Forum | Forum Authority Badge

SQL Server Forum posting activity graph:

Posts by:  day  week  month 
 

http://www.sqlmonster.com Alexa graph:

Top authors on SQL Server Forum during last week:

Name
Posts
Erland Sommarskog
47
user's latest post:
SQL 2008 - FILESTREAM...
Published (2009-11-08 20:07:00)
I suspect this is a "how do I do this in Delphi", which is not easy to assist with, since I don't know Delphi. I would guess that you have some error around one of the parameters to OpenSqlFilestream or the import of it. Could you post the code, including how you import OpenSqlFilestream? No promises, but maybe we are able to spot something. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL...
Uri Dimant
40
user's latest post:
TextAlign problem?
Published (2009-11-08 12:50:00)
Using SSRS 2005 (SP3) and having a table control I want to have an expression to align the text in the table Right--Left based on value So far I have  in textAlign property of the cell =IIF(Dataset!FieldName.Value=0 "Right","Left")  --does not work Thanks
Russell Fields
31
user's latest post:
transaction log file growth
Published (2009-11-05 15:17:00)
Mike, If you have a long-running transaction that remains open, it prevents the log space from being reused, which can cause the log file to grow.  Log space can only be backed up and reused back to the oldest still open transaction in the database.  You can investigate using DBCC OPENTRAN to see if that is the case. (Note that even if the transaction is small, it still holds the log space prisoner for all the other...
--CELKO--
30
user's latest post:
Running value but with a string
Published (2009-11-08 00:29:00)
You narrow your solutions by writing in dialect; you increase their scope, maintainability and robustness by sticking to Standards. Having something that runs in only one release of one version of one SQL is not a good thing. But strong dialect code gives you job security.  Even better, write your code in an unsupported version that only you know. I have never worked anywhere that the whole system was in SQL; there is always a front...
Plamen Ratchev
20
user's latest post:
How to determine free time
Published (2009-11-07 01:25:00)
Here is one solution: SELECT slot_start, slot_end,        DATEADD(MINUTE, DATEDIFF(MINUTE, slot_start, slot_end), 0) AS duration FROM ( SELECT end_time AS slot_start,       (SELECT MIN(CAST(B.StartTime AS DATETIME))        FROM MyClasses AS B        WHERE CAST(B.StartTime AS DATETIME) > end_time) AS...
Eric Isaacs
16
user's latest post:
looking for statement split tool
Published (2009-11-06 23:49:00)
SQL Prompt from Red-Gate.com is an awesome tool for reformatting your SQL to make it more readable.  It adds intellisense functionality to SQL Server 2000 and 2005 (2008 has it built-in) as well as the reformatting options.  The reformatting is a huge reason why we use it, so that all our SQL from all our developers uses a similar format and each developer gets used to the standardized format. Well formatted SQL is much...
Hugo Kornelis
16
user's latest post:
looking for statement split tool
Published (2009-11-06 23:39:00)
Hi aspfun, Maybe this site helps: http://www.sqlinform.com/ (And then choose the "try it online" option). Signature Hugo Kornelis, SQL Server MVP My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Tony Rogerson
15
user's latest post:
Join query returns to many rows
Published (2009-11-08 08:55:00)
Precisely why you should never code using the original ansi 89 style and use infix instead... Never code like this... FROM {tbl} as a, {tbl} as b WHERE a.tblkey = b.tblkey      AND a.postertype = 'opinionated'      AND a.postername = '--celko--' Instead you should write like the majority of other folk do.... FROM {tbl} as a    INNER JOIN {tbl} as b ON...
Tom Cooper
13
user's latest post:
Join query returns to many rows
Published (2009-11-06 02:12:00)
No, both of those queries would do the same thing.  Distinct would apply to all columns in both cases and compare the lastname and firstname and address fields to determine if the row is a duplicate. Tom > Hello Hugo and thank you for the explanation > [quoted text clipped - 44 lines] >> in the old, smaller subset of columns now no longer are duplicates so >> they are no longer removed.
John Bell
11
user's latest post:
Modify statement to run...
Published (2009-11-07 20:45:00)
To expand on this, when you need a quote in a string it has to be escaped with another single quote. John > How about this > [quoted text clipped - 27 lines] >> VALUES('444' + '~', 'EEE')' >> exec sp_executesql @sql
 

Top 10 active forums on SQL Server Forum during last week:

SQL - 362 new posts SQL - forum profile
SQL Server - 140 new posts SQL Server - forum profile
Reporting Services - 56 new posts Reporting Services - forum profile
Other SQL Server Topics - 43 new posts Other SQL Server Topics - forum profile
Setup - 34 new posts Setup - forum profile
Clustering - 28 new posts Clustering - forum profile
Replication - 26 new posts Replication - forum profile
Integration Services - 19 new posts Integration Services - forum profile
Analysis (OLAP) - 16 new posts Analysis (OLAP) - forum profile
Security - 9 new posts Security - forum profile
 

Top 10 forums on SQL Server Forum:

SQL - 16,960 posts SQL - forum profile
SQL Server - 10,403 posts SQL Server - forum profile
Other SQL Server Topics - 4,541 posts Other SQL Server Topics - forum profile
Reporting Services - 3,712 posts Reporting Services - forum profile
Setup - 3,124 posts Setup - forum profile
Replication - 2,744 posts Replication - forum profile
Analysis (OLAP) - 2,198 posts Analysis (OLAP) - forum profile
Integration Services - 2,153 posts Integration Services - forum profile
Security - 2,109 posts Security - forum profile
Clustering - 1,958 posts Clustering - forum profile

Latest active threads on SQL Server Forum:

SQL Server Forum
Started 4 days, 22 hours ago (2009-11-05 17:39:00)  by Jeffrey Williams
Remove the period from the extension. > I have SQL Server 2005 SP2. The maintenance plan is set to: > Search folder and delete files based on an extension [quoted text clipped - 5 lines] > > The files are not being deleted. Any suggestions?
Forum:  SQL Server SQL Server - forum profile
Thread:  Show this thread (5 posts) Thread info: 2005 Maintenance Plan Size: 343 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 2005 Maintenance Plan :: SQL Server :: SQL Server Forum"
SQL Server Forum
Started 16 hours, 30 minutes ago (2009-11-10 00:08:00)  by Andrew J. Kelly
Yes you can but whether it affects your users or not depends on the hardware configuration, system load and application data access. I suggest you run it on low peak times if possible. Signature Andrew J. Kelly SQL MVP Solid Quality Mentors > Can I run the DBCC CHECKDB WITH DATA_PURITY on Production server while > every > body is working?
Forum:  SQL Server SQL Server - forum profile
Thread:  Show this thread (2 posts) Thread info: DBCC CHECKDB WITH DATA_PURITY on production Size: 550 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: DBCC CHECKDB WITH DATA_PURITY on production :: SQL Server :: SQL Server Forum"
SQL Server Forum
Started 2 weeks, 5 days ago (2009-10-22 03:42:00)  by --CELKO--
I did a quick look tonight while babysitting; it seems to be cursors and loops -- things that are faster in procedural languages. If you have a copy of SQL FOR SMARTIES, look at Codd's T-JOIN and its solutions. The example is classrooms with (n) seats and (k) students in a class. It depends on a ordering. A proper SQL/RDBMS solution would give ALL valid answers. So if all items are of size ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (14 posts) Thread info: bin packing Size: 781 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: bin packing :: SQL :: SQL Server Forum"
SQL Server Forum
Started 18 hours, 21 minutes ago (2009-11-09 22:17:00)  by Erland Sommarskog
That is not a statement, but it's an expression. And a syntactically incorrect one, since a parenthesis is missing after "tbl_login". Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970 .aspx SQL 2000: http://...
Forum:  Other SQL Server Topics Other SQL Server Topics - forum profile
Thread:  Show this thread (3 posts) Thread info: SQL case statement Size: 686 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL case statement :: Other SQL Server Topics :: SQL Server Forum"
SQL Server Forum
Started 18 hours, 23 minutes ago (2009-11-09 22:15:00)  by Erland Sommarskog
convert(char(8), getdate(), 112) + replace(convert(char(8), getdate(), 108), ':', '') Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970 .aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousvers ions/...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (6 posts) Thread info: 14 byte date/time in file name Size: 629 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 14 byte date/time in file name :: SQL :: SQL Server Forum"
SQL Server Forum
Started 3 days, 21 hours ago (2009-11-06 19:01:00)  by Jesse O
Anyone? :)
Forum:  Analysis (OLAP) Analysis (OLAP) - forum profile
Thread:  Show this thread (4 posts) Thread info: Locking while processing a dimension in SSAS2008 Size: 437 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Locking while processing a dimension in SSAS2008 :: Analysis (OLAP) :: SQL Server Forum"
 

Hot threads for last week on SQL Server Forum:

SQL
RE: local temp tables - 27 new posts
Started 1 week, 4 days ago (2009-10-29 18:33:00)  by Russell Fields
Ralph, It is not supposed to be necessary, but there have been bugs such as Aaron describes here. http://www.eggheadcafe.com/software/aspnet/3278561 6/q-scope-of-table-variabl.aspx I also experienced problems in the past (longer ago that Aaron's experience) where the automatic cleanup had not happened by the time I tried to create the same temp table again. Talk about mysterious. If you ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (40 posts) Thread info: local temp tables Size: 1,082 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: local temp tables :: SQL :: SQL Server Forum"
SQL
Started 1 week ago (2009-11-03 00:50:00)  by --CELKO--
"A problem well stated is a problem half solved." -- Charles F. Kettering Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how, follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats. Code should be in Standard SQL as much...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (14 posts) Thread info: Join query returns to many rows Size: 993 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Join query returns to many rows :: SQL :: SQL Server Forum"
SQL
Started 1 week ago (2009-11-03 12:35:00)  by Uri Dimant
Hmm, see if this helps you http://dimantdatabasesolutions.blogspot.com/2007/0 8/foreign-key-dependency.html > Good day. > [quoted text clipped - 10 lines] > Kind regards > Christo
Forum:  SQL SQL - forum profile
Thread:  Show this thread (13 posts) Thread info: List all the relations without constraints Size: 291 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: List all the relations without constraints :: SQL :: SQL Server Forum"
SQL
RE: Transaction load - 13 new posts
Started 2 days, 22 hours ago (2009-11-07 17:39:00)  by Farmer
Mike, What is the point in wrapping each file upload into transaction? Each INSERT is atomic transaction already, lasting the length of insert. If you always had 3 related files coming and you needed to upload them as unit, and ensure that all are loaded or all fail, then explicit wrapper transaction is a valid approach. If you have appropriate size SQL Server, this should be no problem. if...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (13 posts) Thread info: Transaction load Size: 837 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Transaction load :: SQL :: SQL Server Forum"
SQL
Started 6 days, 19 hours ago (2009-11-03 20:48:00)  by David Portas
A query used in the FROM clause is called a "derived table subquery" because it returns some rows of data exactly as if that data existed in a table. Think of it as a function used as input to another function. The main syntax rules are that the derived table must have an alias (X in your example) and that all the columns in the query must have unique names. Un-named and duplicate column ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (10 posts) Thread info: Subquery in the FROM clause Size: 609 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Subquery in the FROM clause :: SQL :: SQL Server Forum"
SQL
Started 6 days, 18 hours ago (2009-11-03 21:54:00)  by Plamen Ratchev
Something like this: SELECT O.zipcode, city FROM #Order AS O JOIN tZipcode AS Z ON O.zipcode = Z.zipcode; Signature Plamen Ratchev http://www.SQLStudio.com
Forum:  SQL SQL - forum profile
Thread:  Show this thread (10 posts) Thread info: How to join [Zipcode] in #Order with a table tZipcode to get city name? Size: 346 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to join [Zipcode] in #Order with a table tZipcode to get city name? :: SQL :: SQL Server Forum"
SQL
RE: Stored View - 9 new posts
Started 5 days, 3 hours ago (2009-11-05 13:17:00)  by Uri Dimant
simon See if this helps you CREATE VIEW dbo.v_Sells WITH SCHEMABINDING AS SELECT productID, cntID, SUM(stock) AS stock, sell=SUM(CASE WHEN 4*sellWeek<sellMonth THEN sellMonth ELSE sellWeek END, COUNT_BIG(*) AS counter FROM dbo.stockTable GROUP BY productID, cntID CREATE unique clustered INDEX here........ > Hi, > [quoted text clipped - 14 lines] > FROM dbo.stockTable > GROUP BY ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (9 posts) Thread info: Stored View Size: 550 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Stored View :: SQL :: SQL Server Forum"
SQL
Started 4 days, 13 hours ago (2009-11-06 03:02:00)  by Erland Sommarskog
SELECT R.* FROM Routes R WHERE EXISTS (SELECT TOP(1) * FROM NearestPoints NP WHERE NP.Id = R.Id ORDER BY NP.n, NP.dist) Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207 .aspx SQL 2005: ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (9 posts) Thread info: Select syntax confusion Size: 987 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Select syntax confusion :: SQL :: SQL Server Forum"
SQL
Started 1 week ago (2009-11-02 22:02:00)  by Eric Isaacs
SELECT is used to return a result set to a client or to assign values to variables. SET can also be used to assign values to variables. Here select calls a function that assigns the value to a variable...resulting in NO result set. SELECT @ReturnValue = dbo.SomeFunction(); Stored Procedures can have result sets and return values and output parameters, all of which can return values to the ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (9 posts) Thread info: Does SELECT instruct Sql Server to…? Size: 933 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Does SELECT instruct Sql Server to…? :: SQL :: SQL Server Forum"
SQL
Started 3 days, 17 hours ago (2009-11-06 23:19:00)  by Hugo Kornelis
Hi Klem, Simple - because that are the limitation the development team chose to put in place. <speculation mode on> Allowing these options would probably allow users to write queries that were too hard to figure out how to do, or that would require more development time than was necessary. Evey option allowed adds to the complexion of the final product. Remember that if an option is allowed, ...
Forum:  SQL SQL - forum profile
Thread:  Show this thread (9 posts) Thread info: Why can’t recursive queries contain...? Size: 2,660 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why can’t recursive queries contain...? :: SQL :: SQL Server Forum"