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 | Forum profile

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.

Site: SQL Server Forum - SQL (site profile, domain info sqlmonster.com)
Title: SQL
Url: http://www.sqlmonster.com/Uwe/Forums.aspx/sql-s...
Users activity: 28 posts per thread
Forum activity: 173 active threads during last week
 

Posting activity on SQL:

  Week Month 3 Months
Threads: 173 516 1,371
Post: 481 1,391 3,786
 

SQL Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Plamen Ratchev
31
user's latest post:
Query Help.
Published (2009-11-25 20:12:00)
FOR XML PATH is used to generate XML from a result set. When you use it with blank element name it results in XML without element names and concatenating the column values with ',' results in one concatenated string. Then STUFF is simply used to remove the first comma. Signature Plamen Ratchev http://www.SQLStudio.com
Erland Sommarskog
26
user's latest post:
bulk insert a csv file into a...
Published (2009-11-25 23:08:00)
So the data look like this:  first field"second field"third field""fifth field Assuming that the file has the fields in the same order as the columns in the table this is easy with BULK INSERT:   BULK INSERT Testtable FROM 'C:\test\test.csv'    WITH (DATAFILETYPE = 'char', FIELDTERMINATOR = '"') It would be simple with BCP too, if it...
--CELKO--
21
user's latest post:
Query Help.
Published (2009-11-25 21:45:00)
You have a lot of FUNDAMENTAL problems.  Let's start with the basics of RDBMS; every table a has a key; by definition a key is NOT NULL. Therefore, the only po9ssible key in your DDL is "license_id"; but by definition a key is UNIQUE. In short, you posted a deck of 1950's punch cards and think you are writing SQL. Next, the basis of all RDBMS is the First Normal Form (1NF).  That means all columns...
Tom Cooper
17
user's latest post:
How to write a trigger that...
Published (2009-11-25 22:19:00)
A trigger is called once per statement, not once per row that is updated. So you need to write the trigger to handle multiple rows (by matching the rows in the inserted table with the rows in your base table on the primary key of the base table).  The trigger for this case could be Create Trigger trTable_1 On dbo.Table_1 For Insert, Update As Begin  Update t  Set MyValueCopy = i.MyValue  From dbo.Table_1 t...
Uri Dimant
15
user's latest post:
tough sql statement help please
Published (2009-11-25 15:40:00)
What is the version of SQL Server are you using? > Howdy - and thank you in advance for any help!!! > Here is what I have so far: [quoted text clipped - 29 lines] > g.beginingdate > g.endingdate
Michael Coles
15
user's latest post:
Need help with Indexed View that...
Published (2009-11-25 16:13:00)
If you put the query I gave you in a table-valued function or stored proc and pass in the SKU as a parameter, and add the SKU to the WHERE clause predicate you will probably see acceptable performance.  The key is that you're doing this for one SKU at a time, so with a little index-tweaking on your tables I would imagine your performance would be good. > Thank you both for your responses. > [quoted text clipped - 91...
Kalen Delaney
10
user's latest post:
column with UNIQUE and NOT NULL...
Published (2009-11-18 07:04:00)
Hi AliRezaGoogle You are mixing up logical and physical constructs. Keys are a logical construct, just an expression of the behavior you want. Physical constructs are the actual method of implementation. If you declare a primary key, SQL Server will implement that with a non-null unique index.  The default is to make it a clustered index, but that is not necessary. (The non-null and unique IS necessary. ) In fact, in many cases...
Dan Guzman
10
user's latest post:
Unable to insert record in table
Published (2009-11-25 13:44:00)
The blocking resource could be a key range lock, individual locks multiple keys or some other resource.  The only way to know for sure is catch the problem in action.  From an app perspective, check to ensure that transactions don't span user interactions and select results are consumed quickly and in their entirety. Signature Hope this helps. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/
Tony Rogerson
9
user's latest post:
Localized Tables
Published (2009-11-24 18:04:00)
Hi Iain, Try reading this: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/11/427.aspx Puts to bed some of the misnomers on Codd and surrogate keys. Tony >>>> Well, this is my idea and questions. Am I planning this correctly?<< >> [quoted text clipped - 18 lines] > key, in that only part of the number has independant meaning, the rest > is just a counter, much...
Michael C
9
user's latest post:
Why can’t recursive queries...
Published (2009-11-25 05:41:00)
"Michael Coles" <admin@geocodenet.com> wrote in message news:%23hvu% > I think there are some advantages that could be realized by adding > additional parameters to SQL CLR custom aggregates, and from what I > understand that is on the radar for future versions of SQL Server.  In the > meantime you can work around the issue by using SQL CLR UDTs and passing > them to...
 

Latest active threads on SQL::

SQL Server Forum
Started 5 hours, 32 minutes ago (2009-11-26 19:37:00)  by Russell Fields
Miguel, It depends, of course. If your countries _always_ have regions, then you can simply have your Centers refer to the Regions. If, however, one of the Countries does not have Regions you will have to either: 1. Carry both CountryID and RegionID in the Centers 2. Force an artificial Region for every Country. RLF > Hello, > [quoted text clipped - 18 lines] > Thanks, > Miguel
Thread:  Show this thread (3 posts)   Thread info: Country > Region Size: 517 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Country > Region :: SQL :: SQL Server Forum"
SQL Server Forum
Started 5 hours, 36 minutes ago (2009-11-26 19:33:00)  by Russell Fields
Peter, I am sorry, but I do not fully understand what you are asking, but since it is related to permissions you might find the following useful: http://www.sommarskog.se/grantperm.html This is about giving permissions to stored procedures, but I believe that it explains things enough for you to leverage your problem. (If this does not help, actual code of a simple stored procedure and ...
Thread:  Show this thread (5 posts)   Thread info: Question on Triggers Size: 787 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Question on Triggers :: SQL :: SQL Server Forum"
SQL Server Forum
Started 6 hours, 47 minutes ago (2009-11-26 18:22:00)  by Plamen Ratchev
The FLOAT data type is a good choice. Signature Plamen Ratchev http://www.SQLStudio.com
Thread:  Show this thread (4 posts)   Thread info: Data Type Size: 249 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Data Type :: SQL :: SQL Server Forum"
SQL Server Forum
Started 3 days, 16 hours ago (2009-11-23 08:27:00)  by Erland Sommarskog
The basic structure is the same as we have in our database. The one difference is that we also have a Title column in the main database, which holds the name of the item in the system language. This is intended to be a fallback if the name is missing in a certain language. Queries typically go: somename = coalesce(local.Title, main.Title) ... FROM Articles main LEFT JOIN ...
Thread:  Show this thread (10 posts)   Thread info: Localized Tables Size: 2,707 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Localized Tables :: SQL :: SQL Server Forum"
SQL Server Forum
Started 2 days, 2 hours ago (2009-11-24 23:00:00)  by Erland Sommarskog
Since I don't know SSIS, I cannot help you, but why are the columns nullable in the first place? Overall, the table seem have a lot of nullable columns. I don't know this is about, but it's difficult to understand what NULL in file_name would mean. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/...
Thread:  Show this thread (7 posts)   Thread info: 2005 - Integer may not be NULL but is Size: 806 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 2005 - Integer may not be NULL but is :: SQL :: SQL Server Forum"
SQL Server Forum
Started 9 hours, 21 minutes ago (2009-11-26 15:48:00)  by Erland Sommarskog
More exactly, this time data is read from cache and not from disk. The result set per se is not cached. Autostats may also be of importance. The first query may have to scan the table, and SQL Server takes the chance to create statistics, and next time it finds a better plan. > The second part of the question was: > [quoted text clipped - 4 lines] > I couldn't answer this part. > Can ...
Thread:  Show this thread (7 posts)   Thread info: Interview question... Size: 1,672 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Interview question... :: SQL :: SQL Server Forum"
SQL Server Forum
Started 12 hours, 44 minutes ago (2009-11-26 12:25:00)  by Erland Sommarskog
That is certainly what SET CONTEXT_INFO is intended for. > N.B. We are using many tableadapters on the app so will not have a > centralised place to write the CONTEXTINFO once. We will have to write [quoted text clipped - 3 lines] > populate CONTEXT_INFO, call underlying data modification method, clear > CONTEXT_INFO (still using S2K...), and close connection.
Thread:  Show this thread (5 posts)   Thread info: CONTEXT_INFO - any plans for future deprecation? Size: 1,471 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: CONTEXT_INFO - any plans for future deprecation? :: SQL :: SQL Server Forum"
SQL Server Forum
Started 7 hours, 38 minutes ago (2009-11-26 17:31:00)  by Sylvain Lafontaine
Sorry, wrong address, please discard the previous message. Too many windows open. Signature Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) > Salut Pierre, > [quoted text clipped - 6 lines] > > Merci,
Thread:  Show this thread (2 posts)   Thread info: Facturation et nouveau site web Size: 614 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Facturation et nouveau site web :: SQL :: SQL Server Forum"
SQL Server Forum
Started 1 day, 16 hours ago (2009-11-25 08:43:00)  by Uri Dimant
Hi Do you have lastest service pack? What if you insert the data via query builder rather than SSMS? > Hi, > [quoted text clipped - 37 lines] > Professional Office Developer Association > www.proofficedev.com
Thread:  Show this thread (8 posts)   Thread info: Unable to insert record in table Size: 332 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Unable to insert record in table :: SQL :: SQL Server Forum"
SQL Server Forum
Started 2 days, 10 hours ago (2009-11-24 14:42:00)  by TheSQLGuru
1) what do you mean "retry"? can you explain the objective a bit better? 2) if possible, I recommend moving the person information to one table with a primary key. then put the skills (0-n of them) in a separate table that has the PK from the person table. this is basic data normalization, which is something you probably should start learning about. 3) may I ask - is this a homework ...
Thread:  Show this thread (11 posts)   Thread info: Select Query Problem Size: 838 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Select Query Problem :: SQL :: SQL Server Forum"
 

Hot threads for last week on SQL::

SQL
Started 2 weeks, 6 days 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, ...
Thread:  Show this thread (32 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"
SQL
Started 1 week, 1 day ago (2009-11-18 22:06:00)  by Electro Lytes
Because in his warped mind, the world revolves around CELKO.
Thread:  Show this thread (18 posts)   Thread info: ISO SQL Date Format / ISO Date Formats - question to --CELKO-- on your
continued misuse of the inconsistent date formats in your advice Size: 70 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: ISO SQL Date Format / ISO Date Formats - question to --CELKO-- on your
continued misuse of the inconsistent... :: SQL :: SQL Server Forum"
SQL
Started 2 days, 10 hours ago (2009-11-24 14:42:00)  by TheSQLGuru
1) what do you mean "retry"? can you explain the objective a bit better? 2) if possible, I recommend moving the person information to one table with a primary key. then put the skills (0-n of them) in a separate table that has the PK from the person table. this is basic data normalization, which is something you probably should start learning about. 3) may I ask - is this a homework ...
Thread:  Show this thread (11 posts)   Thread info: Select Query Problem Size: 838 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Select Query Problem :: SQL :: SQL Server Forum"
SQL
Started 1 week, 1 day ago (2009-11-18 15:40:00)  by Plamen Ratchev
On SQL Server 2008 you can use a table-valued parameter: CREATE TYPE store_type AS TABLE (storeid INT); GO DECLARE @t store_type; INSERT INTO @t (storeid) VALUES(1); EXEC sp_executesql N'SELECT storeid FROM @t', N'@t store_type READONLY', @t; GO DROP TYPE store_type; Signature Plamen Ratchev http://www.SQLStudio.com
Thread:  Show this thread (9 posts)   Thread info: Dynamic SQL againest a table variable Size: 690 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Dynamic SQL againest a table variable :: SQL :: SQL Server Forum"
SQL
RE: Localized Tables - 9 new posts
Started 3 days, 16 hours ago (2009-11-23 08:27:00)  by Erland Sommarskog
The basic structure is the same as we have in our database. The one difference is that we also have a Title column in the main database, which holds the name of the item in the system language. This is intended to be a fallback if the name is missing in a certain language. Queries typically go: somename = coalesce(local.Title, main.Title) ... FROM Articles main LEFT JOIN ...
Thread:  Show this thread (10 posts)   Thread info: Localized Tables Size: 2,707 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Localized Tables :: SQL :: SQL Server Forum"
SQL
Started 1 week, 1 day ago (2009-11-18 07:04:00)  by Kalen Delaney
Hi AliRezaGoogle You are mixing up logical and physical constructs. Keys are a logical construct, just an expression of the behavior you want. Physical constructs are the actual method of implementation. If you declare a primary key, SQL Server will implement that with a non-null unique index. The default is to make it a clustered index, but that is not necessary. (The non-null and unique ...
Thread:  Show this thread (8 posts)   Thread info: column with UNIQUE and NOT NULL equivalent to a PRIMARY KEY ? Size: 1,293 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: column with UNIQUE and NOT NULL equivalent to a PRIMARY KEY ? :: SQL :: SQL Server Forum"
SQL
Started 3 days, 18 hours ago (2009-11-23 06:44:00)  by Balaji
Hi Sam, You query may be some thing like this... select * from table where datetimecol >= convert(varchar(30),dateadd(mi,-30,GETDATE()),108) Regards, Balaji > Hi all, > [quoted text clipped - 22 lines] > Regards, > sam
Thread:  Show this thread (8 posts)   Thread info: Display data every 30 minutes interval Size: 338 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Display data every 30 minutes interval :: SQL :: SQL Server Forum"
SQL
Started 1 day, 16 hours ago (2009-11-25 08:43:00)  by Uri Dimant
Hi Do you have lastest service pack? What if you insert the data via query builder rather than SSMS? > Hi, > [quoted text clipped - 37 lines] > Professional Office Developer Association > www.proofficedev.com
Thread:  Show this thread (8 posts)   Thread info: Unable to insert record in table Size: 332 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Unable to insert record in table :: SQL :: SQL Server Forum"
SQL
Started 1 week, 1 day ago (2009-11-18 03:24:00)  by Sylvain Lafontaine
Even when a UDF function us already clearly deterministic, you must create it using the WITH SCHEMABINDING option if you want to use it with a computed column in a View. See also the following answer from Kalen to know how to determine if a function is deterministic or not: http://www.eggheadcafe.com/software/aspnet/3141945 8/indexed-view--non-determ.aspx Signature Sylvain Lafontaine,...
Thread:  Show this thread (7 posts)   Thread info: Why is this non-deterministic Size: 1,010 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why is this non-deterministic :: SQL :: SQL Server Forum"
SQL
Started 1 week ago (2009-11-19 14:10:00)  by Erland Sommarskog
To start with it's "authentication" in this weird foreign language they use in this newsgroup. :-) To be able to log in with Windows authentication, your Windows account must have been granted access to SQL Server. This can be done in two ways: directly, or indirectly through a Windows group of which you are a member. This can be very practical, as user membership then only needs to be ...
Thread:  Show this thread (7 posts)   Thread info: about autentisering Size: 1,774 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: about autentisering :: SQL :: SQL Server Forum"