|
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:
|
484
|
1,663
|
4,395
|
|
Post:
|
953
|
3,184
|
9,103
|
|
|
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:
recovery mode
Published (2009-11-20 23:12:00)
Wrong question. The right question is: if the database goes belly-up how much can you afford to lose? Is it OK to restore the most recent backups (you are taking backups, aren't you?), or are you content with losing recent updates? And this is not meant to be a rhethoric question, but a real one that you need to ask yourself. Full recovery will help you reduce data-loss in case of a disaster. But it comes with a cost, as it incurs more...
user's latest post:
DBCC CheckDB
Published (2009-11-20 09:10:00)
If you have a job you can add an ouptut file for each server > Hello, > [quoted text clipped - 9 lines] > Thanks, > Jean
user's latest post:
Stored Procedure Update on...
Published (2009-11-20 11:24:00)
Hi Phil, In my view you should write a script that will connect to each remote server and execute your change script. Since you already have added all the remote server(s) as linked servers in your SQL Server this should not be tough task. Regards, Balaji > Hi, > [quoted text clipped - 21 lines] > > Thanks for the help.
user's latest post:
INSERT INTO behaviour???
Published (2009-11-20 16:53:00)
The ID column is included in the INSERT/SELECT list so if IDENTITY in the target table then it is forcing existing values and ORDER BY has no effect. It will have effect if there is another column in the target table that is IDENTITY. And sort is by customer id... Signature Plamen Ratchev http://www.SQLStudio.com
user's latest post:
A workaround for SS 2005...
Published (2009-11-20 12:56:00)
partition switching is supported in SQL Server 2005, however there is no GUI for it in SQL Server 2005 Management Studio. What I am confused about is - is the partitioned table in a subscription or a publication? If it is in the publication you should be able to drop the article from the subscription, drop it from the publication, make the change, add it back to the publication, add it back to the subscription doing a no sync, then do a...
user's latest post:
SA Password Change Logging
Published (2009-11-20 17:07:00)
Or using EVENT NOTIFICATION by capturing the DDL events. The ObjectName filed for ALTER LOGIN will have the name of the login whose password is changed. Also, you could just run a trace. Linchi > I have an issue at a company I am doing some contract work for. One of the > members of the admin team keeps changing the SA password but we don't know [quoted text clipped - 6 lines] > I am looking for advice on how we can...
user's latest post:
insert into when not exist in table
Published (2009-11-19 23:51:00)
Is here a UNIQUE (x, y) on table A? Then it will not happen. Think constraints before code!!
user's latest post:
table design
Published (2009-11-20 13:37:00)
One method is to add another column (e.g. site_id) and use the composite of site_id and work_order_number_id as the primary key. Another approach is to use a uniqueidentifier data type for work_order_number_id so that you can use GUID values as the surrogate primary key. Signature Hope this helps. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/
user's latest post:
Null in SQL 2005/2008
Published (2009-11-20 17:02:00)
I certainly don't mind if you read my book. It is available in many large bookstores and orderable from Amazon, Barnes&Noble, etc. I suggest you start a new thread to ask a question on a different topic, so people answering it and also those interesting in the answer don't get confused with it buried deep in this other thread. Signature HTH Kalen ---------------------------------------- Kalen Delaney SQL Server MVP...
user's latest post:
SQL 2000 Server Waits
Published (2009-11-19 03:19:00)
Serious "it depends" question there! Get a professional in to review your database application and advise you. You could go back and forth for days on this forum to try to nail this down. Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net >I ran a track_waits script for 10 minutes to see what is getting the most >waits. It turns out to be...
|
|
|
Top 10 active forums on SQL Server Forum during last week:
|
|
Top 10 forums on SQL Server Forum:
SQL
- 17,508 posts
|
SQL Server
- 10,702 posts
|
Other SQL Server Topics
- 4,617 posts
|
Reporting Services
- 3,795 posts
|
Setup
- 3,175 posts
|
Replication
- 2,813 posts
|
Analysis (OLAP)
- 2,221 posts
|
Integration Services
- 2,172 posts
|
Security
- 2,147 posts
|
Clustering
- 1,980 posts
|
|
|
|
|
Latest active threads on SQL Server Forum:
Started 12 hours, 48 minutes ago (2009-11-22 09:07:00)
by Uri Dimant
Hi > Can I see that database using Sql Server Management Studio Express
Started 11 hours, 30 minutes ago (2009-11-22 10:25:00)
by Erland Sommarskog
Yes, there is no upgrade path between x86 and x64. One way is to install SQL 2008 as a named instance on the machine. You can then keep the SQL 2000 instance, and copy the databases with backup/restore to the SQL 2008. The advantage with this is that you can keep SQL 2000 as a reference, in case you have query that starts to perform badly on SQL 2008. (By the way, make sure that you update ...
Started 3 days, 23 hours ago (2009-11-18 22:06:00)
by Electro Lytes
Because in his warped mind, the world revolves around CELKO.
Started 2 days, 5 hours ago (2009-11-20 16:49:00)
by Bruce L-C [MVP]
Vista and Windows 7 both have additional security. It doesn't matter that you are logged in as administrator, if you don't run a program with enhanced rights ( run as administrator or something like that) then you run with limited rights. On Windows 7 I had the issue with using IE to connect to RS on the same box. I got around it by opening up IE with enhanced rights. I bet if you do this ...
Started 1 day, 3 hours ago (2009-11-21 18:04:00)
by Plamen Ratchev
CASE expressions return a scalar value with singe data type. If your columns are compatible data type then you can write the query as follows: SELECT CASE @who WHEN 'me' THEN col1 WHEN 'him' THEN col4 WHEN 'them' THEN col1 ELSE '' END AS col1, CASE @who WHEN 'me' THEN col2 WHEN 'him' THEN col5...
Started 1 week, 1 day ago (2009-11-14 02:47:00)
by --CELKO--
T-SQL was not meant to be 3GL full language. That is ANSI/ISO Standard SQL/PSM. But you need to worry more the declarative features that are missing, if you are writing proper SQL.
Started 3 days, 18 hours ago (2009-11-19 03:15:00)
by TheSQLGuru
Brian Larson has a good book on SSRS that has a complete sample database (and code, etc). Good stuff, IMHO. Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net > Which sample DB(s) would be good for playing with SSRS (and maybe SSIS) on > SQL Server 2008 (and where can I get them)?
Started 2 days, 8 hours ago (2009-11-20 12:56:00)
by Hilary Cotter
partition switching is supported in SQL Server 2005, however there is no GUI for it in SQL Server 2005 Management Studio. What I am confused about is - is the partitioned table in a subscription or a publication? If it is in the publication you should be able to drop the article from the subscription, drop it from the publication, make the change, add it back to the publication, add it back...
|
|
Hot threads for last week on SQL Server Forum:
Started 3 days, 23 hours ago (2009-11-18 22:06:00)
by Electro Lytes
Because in his warped mind, the world revolves around CELKO.
Started 1 week, 1 day ago (2009-11-14 16:53:00)
by Dan Guzman
Different plans often results in different performance. Even though the second query is expressed in a more complex way, the optimizer can refactor the query and avoid redundant data access. SQL Server often yields identical (and optimal) plans for semantically identical queries but there are some cases where it misses the mark. This is especially true when useful indexes don't exist....
Started 4 days ago (2009-11-18 21:24:00)
by Kalen Delaney
Hi od This is NOT true, and has not been true since 7. The article that said it applied to SQL 7 was mistaken. Starting in SQL 7, all internal storage formats changed. Fixed length columns, whether NULL or not, always take the FULL column length. Only variable length columns will store NULLs in zero bytes. > if a table has a Date > field, a long integer field, an integer field, a ...
Started 1 week, 1 day ago (2009-11-14 20:31:00)
by Eric Isaacs
If you're deleting one row from one table and you're getting those kinds of errors, I'm guessing there is more at play here than just a lot of data. Is the insertdate indexed? If it is not, then to delete even just one row, the millions of rows need to be filtered by that date. Try adding an index to that field first, and see where that takes you. If it's indexed, then I would be wondering if...
Started 1 week ago (2009-11-15 05:05:00)
by Sylvain Lafontaine
Try with Auto_Fix instead; see the example at the end of the following article: http://msdn.microsoft.com/en-us/library/ms174378.a spx Signature Sylvain Lafontaine, ing. MVP - Windows Live Platform Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please) Independent consultant and remote programming for Access and SQL-Server (French) > Hello. > [quoted text ...
Started 6 days, 1 hour ago (2009-11-16 20:41:00)
by Sylvain Lafontaine
Yes, you need to use a join; something like (untested): Select M.*, S.*, D.*, C.* From main as M inner join streets S on M.street_id = S.street_id inner join Docs D on M.doctor_id = D.doctor_id inner join conditions C on M.condition_id = C.condition_id Where M.name = 'test' Notice that if you have some missing records in one or more tables, you should use a LEFT JOIN instead of an ...
Started 5 days, 2 hours ago (2009-11-17 19:24:00)
by Peso
WHERE Col1 = Col2 AND Col2 = Col3 //Peso > I would like to write a query that pulls records where the value in 3 > different Columns is the same. [quoted text clipped - 12 lines] > Field1 | Field2 | Field3 | > 175 26 15
Started 1 week, 5 days 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 5 days, 4 hours ago (2009-11-17 17:05:00)
by ML
Create a non-cascading foreign key relationship and use a stored procedure to delete the rows in the correct order (foreign table(s) first, primary table(s) last). ML --- Matija Lah, SQL Server MVP http://milambda.blogspot.com/
Started 4 days, 6 hours 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
|
|