|
More site info...
|
|
Forum profile page for SQL on http://www.sqlmonster.com.
This report page is the aggregated overview from a single forum: SQL, located on the Message Board at http://www.sqlmonster.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL" on the Message Board at http://www.sqlmonster.com is also shown in the following ways:
1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
173
|
463
|
1,401
|
|
Post:
|
426
|
1,233
|
4,038
|
|
|
SQL Posting activity graph:
|
Top authors during last week:
user's latest post:
Find approximate values
Published (2009-11-10 21:50:00)
Mop the floor, but fix the leak. Add a CHECK (foobar LIKE '[A-Z][A-Z] [A-Z]') to the table so that the bad data never gets into the database. Let the applications do data scrubbing on their side of the system.
user's latest post:
How to update a new column in a...
Published (2009-11-11 18:18:00)
You can use the ANSI update syntax: UPDATE Table1 SET ErrorMsg = (SELECT T.ErrorMsg FROM Temp AS T WHERE T.clientkey = Table1.clientkey) WHERE EXISTS(SELECT * FROM Temp AS T ...
user's latest post:
looping
Published (2009-11-11 14:55:00)
Tony Have you looked into Hugo's solution for running totals ( his chapter in MVP books). It was definitely fast than my another solution , but unfortunately I have not compared it with a cursor. > If he does answer it will be some off topic rant aimed at distracting us > away from the facts in the case in point also - it won't come anywhere [quoted text clipped - 164 lines] >>>>...
user's latest post:
Why can’t recursive queries...
Published (2009-11-11 22:40:00)
That must explain ahy in VB .Net can write: Using cn As SqlConnection = setup_connection(), _ cmd As SqlCommand = cn.CreateCommand() But I in C# has to write: using (SqlConnection cn = setup_connection()) { using (SqlCommand cmd = cn.CreateCommand()) { > That I...
user's latest post:
looping
Published (2009-11-11 16:34:00)
ah - you mean the "don't" rely on the ordering of the rows one. That's been in the product for a long time and its best avoided unless all the criteria are met like uniqueness on the keys and stuff but I don't think using it in this way is good practice. Tony > It will probably be worth mentioning , even in passing, Jeff Modens Quirky > update. [quoted text clipped - 194 lines]...
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:
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:
AdventureWorks database
Published (2009-11-10 21:33:00)
Hi Sql book I’m reading uses extensively AdventureWorks database. But it’s very difficult to follow since I don’t know what exactly the tables and their columns represent ( I realize each column has a descriptive name like RevisionNumber, TaxAmt …but many of these terms are confusing, especially when not seeing the larger picture ), and how these tables ( aka what they represent in real world ) are semantically related to each other....
user's latest post:
Need Help w/ Monthly Sales...
Published (2009-11-10 20:10:00)
Also, you mentioned in your original post that you wanted to keep running totals, I assumed for the year, and each month. Your solution only keeps running totals by SKU by month and restarts each month. Does that meet your requirements? -Eric Isaacs
user's latest post:
SQL 2008 - FILESTREAM...
Published (2009-11-11 15:23:00)
I tried running the program from the remote machine and from the server itself. Sharing files and printers was enabled, also tried with firewall turned off. Regars, Jacek
|
|
|
|
Latest active threads on SQL::
Started 1 week 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, ...
Started 6 days ago (2009-11-08 20:07:00)
by Erland Sommarskog
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,...
Started 3 days ago (2009-11-11 20:25:00)
by Scott Morris
Correct. However, you seem to not quite grasp the difference between char and varchar. BOL should be your first visit. > Likewise, if there are more than 23 and 25 characters, > then the data will not be inserted into those two fields. Also correct?
Started 3 days, 10 hours ago (2009-11-11 10:02:00)
by Uri Dimant
Abba What does the query do? How much rows do you return? > Hello, > [quoted text clipped - 21 lines] > TIA, > AbbA
Started 3 days, 2 hours ago (2009-11-11 18:18:00)
by Plamen Ratchev
You can use the ANSI update syntax: UPDATE Table1 SET ErrorMsg = (SELECT T.ErrorMsg FROM Temp AS T WHERE T.clientkey = Table1.clientkey) WHERE EXISTS(SELECT * FROM Temp AS T WHERE T.clientkey = Table1.clientkey); Or the SQL Server specific update with join (note here that multiple matches on clientkey will result in non-...
Started 3 days, 15 hours ago (2009-11-11 05:00:00)
by Balaji
Hi Bob, sp_MSforeachtable stored procedure is a undocumented stored procedure. It is always best to avoid any undocumented procedure in a production environement. Regards, Balaji > Is sp_MSforeachtable the best approach to maintain the rebuilding of all > indexes > for all tables in a database? > thanks in advance, > ..bob
Started 4 days, 4 hours ago (2009-11-10 16:01:00)
by Simon Whale
change the select select @myremoved1 = @myremoved1 + @myremoved to set @myremoved1 = @myremoved1 + @myremoved Simon > Hi... i have been testing using cursor's. > looping through a select statement, I want put a numeric field into a temp [quoted text clipped - 20 lines] > > any help?
Started 1 week, 1 day ago (2009-11-06 16:39:00)
by Eric Isaacs
The sales data doesn't change after the period is expired, so rather than an indexed view, why not a permanent table to keep these values in? Consider a table like this... Create Table dbo.TotalSales ( TotalSalesID INT IDENTITY(1,1) PRIMARY KEY, ProductSKU INT NOT NULL TotalSalesYear INT NOT NULL, TotalSalesMonth INT NULL, TotalSalesDay INT NULL ) The idea being that the ...
Started 3 days, 15 hours ago (2009-11-11 04:59:00)
by Balaji
Hi Jon, It may be because of isolation level setting. The client may be using read uncommited isolation level. If so ask the client to use read commited isolation level Regards, Balaji >I have a T-SQL stored procedure that inserts a row into one table, then >inserts a row into another table, both tables in the same database. Both [quoted text clipped - 10 lines] > > Thanks.
|
|
Hot threads for last week on SQL::
Started 1 week 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 4 days, 4 hours ago (2009-11-10 16:01:00)
by Simon Whale
change the select select @myremoved1 = @myremoved1 + @myremoved to set @myremoved1 = @myremoved1 + @myremoved Simon > Hi... i have been testing using cursor's. > looping through a select statement, I want put a numeric field into a temp [quoted text clipped - 20 lines] > > any help?
Started 1 week 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, ...
Started 4 days, 4 hours ago (2009-11-10 16:17:00)
by sloan
//I know that I can't use select top or set rowcount.// That's like asking "How can I change the brakes on my car without using a wrench or socket?" ......... Why are you eliminating the EXACT TOOLS you need to perform the job? Q1: Why can't you use the commands you list? > Hopefully this makes sense.... > [quoted text clipped - 6 lines] > > Any help is greatly appreciated.
Started 6 days ago (2009-11-08 20:07:00)
by Erland Sommarskog
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,...
Started 1 week, 1 day 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 4 days, 22 hours 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 1 week, 1 day ago (2009-11-06 16:39:00)
by Eric Isaacs
The sales data doesn't change after the period is expired, so rather than an indexed view, why not a permanent table to keep these values in? Consider a table like this... Create Table dbo.TotalSales ( TotalSalesID INT IDENTITY(1,1) PRIMARY KEY, ProductSKU INT NOT NULL TotalSalesYear INT NOT NULL, TotalSalesMonth INT NULL, TotalSalesDay INT NULL ) The idea being that the ...
Started 1 week ago (2009-11-07 01:56:00)
by mouser
Are you using bulk loading (called "fast load" in SSIS, I believe) in your OLE DB Destination adapter? I don't think you can track particular errors with bulk loading on. If you turn off "Fast Load", the adapter will have an error path you can use to redirect error rows elsewhere. The error path adds "Error Description" and "Error Code" columns to the flow, which you can interrogate for FK ...
Started 1 week, 4 days 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...
|
|