|
More site info...
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.
|
|
|
|
|
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:
|
|
|
BoardReader Authority Badge code for SQL Server Forum (http://www.sqlmonster.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 Forum posting activity graph:
|
|
http://www.sqlmonster.com Alexa graph:
|
Top authors on SQL Server Forum during last week:
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...
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
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...
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...
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...
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...
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
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...
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.
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:
|
|
Top 10 forums on SQL Server Forum:
SQL
- 16,960 posts
|
SQL Server
- 10,403 posts
|
Other SQL Server Topics
- 4,541 posts
|
Reporting Services
- 3,712 posts
|
Setup
- 3,124 posts
|
Replication
- 2,744 posts
|
Analysis (OLAP)
- 2,198 posts
|
Integration Services
- 2,153 posts
|
Security
- 2,109 posts
|
Clustering
- 1,958 posts
|
|
|
|
|
Latest active threads on 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?
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?
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 ...
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://...
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/...
Started 3 days, 21 hours ago (2009-11-06 19:01:00)
by Jesse O
|
|
Hot threads for last week on SQL Server Forum:
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 ...
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...
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
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...
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 ...
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
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 ...
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: ...
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 ...
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, ...
|
|
Size: 343 bytes
