|
More site info...
SQL Server Database Engine | Forum profile
|
|
Forum profile page for SQL Server Database Engine on http://social.technet.microsoft.com.
This report page is the aggregated overview from a single forum: SQL Server Database Engine, located on the Message Board at http://social.technet.microsoft.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 Server Database Engine" on the Message Board at http://social.technet.microsoft.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 Server Database Engine:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
92
|
210
|
1,114
|
|
Post:
|
262
|
546
|
3,394
|
|
|
SQL Server Database Engine Posting activity graph:
|
Top authors during last week:
user's latest post:
My Custom DB Maintenance Plan
Published (2009-11-29 13:57:00)
Jonathan, Looks like I didn't read the post completely and You are right.
user's latest post:
My Custom DB Maintenance Plan
Published (2009-11-29 12:53:00)
David, #3 is wrong to do for all tables after #1. When you rebuild, SQL Server will update the statistics with 100% sampling rate but the #3 overwrites the data with only the default sampling rate i.e 10%. So you loose lot of good benefits by doing #3.
user's latest post:
What is tail of log backup
Published (2009-11-28 17:50:00)
Tail-log backup A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the log). A tail-log backup does not truncate the log and is generally used when the data files for a database have become inaccessible but the log file is undamaged.
user's latest post:
What is tail of log backup
Published (2009-11-28 14:08:00)
One application is when transferring the DB to a different server and after taking the last transaction log (tail log) you do not want any transactional activity in the database. See demo below. Let us know if helpful. -- "SHUTDOWN" for database - preventing additonal activity after last tran backup BACKUP LOG AdventureWorks TO DISK = 'F:\temp\log\AWTailLog.trn' WITH NORECOVERY /* Processed 6 pages for...
user's latest post:
Are SQL Server Deadlocks...
Published (2009-11-28 19:36:00)
Finally, the insert statement is just a single statement, as shown. It is passed from ADO.NET as dynamic SQL via a command object. Thanks again, Jeff
user's latest post:
My Custom DB Maintenance Plan
Published (2009-11-29 09:58:00)
Hi guys, After one of the experts solve my problem here, I came out with my list of my custom maintenance plans. I am planning to run it on weekly basis as my DB is rather huge i.e. 1.8 GB and they are changed quite frequently. Firstly, I am going to do them manually once everything seems okay, I will put them in the scheduled job. 1. Re-build all my indexes ALTER INDEX SOME_INDEX ON SOME_TABLE REBUILD; 2. Re-organize all my full-text indexes...
user's latest post:
Sql Server Dev Edition Not...
Published (2009-11-29 03:43:00)
Can anybody help on this.. without windows authentication, can't do sql stored proc debugging.. Pls help...
user's latest post:
MSSQLSERVER won't start...
Published (2009-11-27 13:55:00)
Nigel, I'm not sure which of the top two it would be. As SQLUSA pointed it, it might be a better option to get things back up and running by installing a new instance. -Sean
user's latest post:
standard view with multiple...
Published (2009-11-25 23:37:00)
ah .. yes aware of those ... thanks again to close thread .. to conclude all .. sql server upto 2008 for non indexed views will always compute aggregates (presume functions too) and all joins for every query regarless of what you select from the view which = bad performance for views for many columns across many tables. thanks Shankar.
user's latest post:
BUG on SQL Server 2008 with...
Published (2009-11-25 17:25:00)
The functionality is implemented in Microsoft SQL Server, but not follow the Standards. To join the SQL Standard, the option 'null' or 'not null' on Index Creation should come from the field definition in Table.
|
|
|
|
Latest active threads on SQL Server Database Engine::
Started 5 days, 17 hours ago (2009-11-29 12:41:00)
by Jonathan Kehayias
You need to add DBCC CHECKDB to the list. A 1.8GB database is actually small for what SQL Server can handle and for that size of database, your maintenance tasks should complete in a few minutes. Ola Hallengren has a very comprehensive set of maintenance scripts for SQL Server that takes all the coding out of the picture: http://ola.hallengren.com/Versions.html
Started 6 days, 2 hours ago (2009-11-29 04:36:00)
by TiborK
Why would you want to do this?
Started 6 days, 22 hours ago (2009-11-28 08:16:00)
by dvdavid2001
Hi guys, An update : It actually not hangs but it finally return the results. It returned the result only after 45 mins. Gosh, that is too slow. Any idea here? -- HANG! I have waited for 40 mins but it never returned anything...it just said that "Executing Query..." -- Update: It retrieved 800+ records after 45 mins. select count(1) from esg_product_latest where result_approved_dt >=...
Started 5 days, 21 hours ago (2009-11-29 09:19:00)
by Suhas V
Hi Vibster, The following commands will give you the desired result
select @@servername
select SERVERPROPERTY('ServerName')
can you please Check whether the server has been configured to allow remote connections. If your SQL Server has not been configured to allow remote connections, then configure your SQL Server.
------------
Thanks,...
Started 1 week, 1 day ago (2009-11-26 18:34:00)
by Lekss
Are you sure that the login that you are using is a DOMAIN ACCOUNT and has access to the windows server 2003 ? Try to logon locally with the same domain account in to the win 2003 server and see if there are any issues.
Started 1 month, 1 week ago (2009-10-28 19:47:00)
by Phil Brammer
See this page for a good reference: http://sqlserverbuilds.blogspot.com/ It looks like 9.00.4053 was a security update.
Started 6 days, 9 hours ago (2009-11-28 21:04:00)
by Jonathan Kehayias
If you are on Enterprise Edition, you can perform index operations ONLINE, but only on Enterprise Edition. You do this by specifying the ONLINE = ON index option for CREATE INDEX or ALTER INDEX: Performing Index Operations Online How Online Index Operations Work
Started 1 week ago (2009-11-27 12:37:00)
by SUB77
Started 1 week, 2 days ago (2009-11-26 03:44:00)
by JimMcLeod
Hi Jeff, SQL Server runs in two modes: AutoCommit Transaction, or Implicit Transaction. AutoCommit transaction is the usual - operations are committed automatically, and new transactions are started and committed automatically. Implicit Transaction mode will automatically start transactions, but must manually commit transactions. This means that every row operation (select/insert/update/...
|
|
Hot threads for last week on SQL Server Database Engine::
Started 1 week, 2 days ago (2009-11-26 03:44:00)
by JimMcLeod
Hi Jeff, SQL Server runs in two modes: AutoCommit Transaction, or Implicit Transaction. AutoCommit transaction is the usual - operations are committed automatically, and new transactions are started and committed automatically. Implicit Transaction mode will automatically start transactions, but must manually commit transactions. This means that every row operation (select/insert/update/...
Started 1 week ago (2009-11-27 12:07:00)
by Alberto Morillo
Hello,
First run, run a diagnostic tool and correct any problems on your storage.
Second, rebuild the master database:
http://msdn.microsoft.com/en-us/library/aa213831(S QL.80).aspx http://msdn.microsoft.com/en-us/library/aa197950(S QL.80).aspx
Finally, try to restore your master database from backup.:
Hope this helps.
Regards, Alberto Morillo ...
Started 1 week ago (2009-11-27 09:03:00)
by Deepak Rangarajan
You are running a transaction that requires more log space as a result autogrowth of log file happens. Take a look at the KB article . If you have SQL 2005 you can make use of instant file initialization refer, http://www.sqlskills.com/BLOGS/PAUL/post/Misconcep tions-around-instant-file-initialization.aspx http://sqlblog.com/blogs/tibor_karaszi/archive/200 9/03/09/do-you-have-instant-file-...
Started 6 days, 22 hours ago (2009-11-28 08:16:00)
by dvdavid2001
Hi guys, An update : It actually not hangs but it finally return the results. It returned the result only after 45 mins. Gosh, that is too slow. Any idea here? -- HANG! I have waited for 40 mins but it never returned anything...it just said that "Executing Query..." -- Update: It retrieved 800+ records after 45 mins. select count(1) from esg_product_latest where result_approved_dt >=...
Started 1 week ago (2009-11-27 20:07:00)
by Adam Tappis
I'll chip in from the non-guru camp. Firstly, taking 15 seconds to process 1000 rows is extremetly slow, you must have some seriously slow disks, or you indexes span many pages and are seriously fragmented. I say this based on your other comments regarding first vs second execution timing. The first time you run your query, SQL server reads the index pages from disk and stores them in the cache...
Started 1 week ago (2009-11-27 07:16:00)
by Sankar Reddy
Nagendra, Have you looked at Microsoft SQL Server Database Publishing Wizard 1.1 ?
Started 1 week, 1 day ago (2009-11-26 15:20:00)
by Ricardo Sampei
Full backups will not remove the inactive portion of the transaction log. The only way to do this is to take transaction log backups. If you are taking transaction log backups periodically but it is still growing then you should look for open transactions, which may be preventing SQL from clearing the inactive portion of the transaction log.
Started 5 days, 17 hours ago (2009-11-29 12:41:00)
by Jonathan Kehayias
You need to add DBCC CHECKDB to the list. A 1.8GB database is actually small for what SQL Server can handle and for that size of database, your maintenance tasks should complete in a few minutes. Ola Hallengren has a very comprehensive set of maintenance scripts for SQL Server that takes all the coding out of the picture: http://ola.hallengren.com/Versions.html
Started 1 week, 1 day ago (2009-11-27 04:06:00)
by Jungsun
As I know, you can't install SQL Server 2005 Ent on Win XP, but available Evaluation Copy. Anyway If you install SQL Server as 'Default Instance', you use the computer_name or (local) or '.' for server _name and choose 'Windows Authentication' for authentication. I hope that helps Thanks
Started 1 week, 1 day ago (2009-11-27 05:07:00)
by Sankar Reddy
Riddhisha,
Did you try creating the indexed view in the same database as the base table and just reference the indexed view as three part name?
If you create the indexed view in AdventureWorks like below then you can reference it in the next code snippet.
CREATE VIEW Vdiscount1 WITH SCHEMABINDING AS
SELECT SUM (UnitPrice*OrderQty) AS SumPrice,
SUM (...
|
|
Size: 465 bytes
