|
More site info...
Getting started with SQL Server | Forum profile
|
|
Forum profile page for Getting started with SQL Server on http://social.technet.microsoft.com.
This report page is the aggregated overview from a single forum: Getting started with SQL Server, 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 "Getting started with SQL Server" 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 Getting started with SQL Server:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
100
|
336
|
888
|
|
Post:
|
288
|
905
|
2,790
|
|
|
Getting started with SQL Server Posting activity graph:
|
Top authors during last week:
user's latest post:
SQL 2005 - Update...
Published (2009-11-27 22:15:00)
Hi Sankar, I was assuming that DBCC INDEXDEFRAG will also update stats but later realised that it will not. So i think the only DBCC command that does update stats is DBCC REINDEX. You are right here , only update statistics in command column will be fetched , if in case user runs sp_updatestats that wont be tracked in the above query..
user's latest post:
tru or false
Published (2009-11-27 15:48:00)
False! An email scam. Links: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.news.server&tid=75cec085-4c25-4715-b8aa-3588d92d5cbe&cat=en_US_9b6d26c4-de58-4d72-93d9-4c56f036b989&lang=en&cr=US&sloc=&p=1 http://www.complaintsboard.com/complaints/microsoft-award-team-baley-house-har-road-sutton-greater-london-sm1-4te-united-a-kingdom-c167975.html...
user's latest post:
Query to calculate percentage
Published (2009-11-25 09:11:00)
It is not giving the correct result.. It gives correct result of household only..
user's latest post:
SQL 2008 T-SQL and MS Access...
Published (2009-11-27 21:24:00)
Hello Jason, When I said VB in the front-end I was talking about the VBA inside Access. When you open Access and press ALT+F11 you will open a Visual Basic for Applications editor. That editor is available for every existing Office applications including Excel, Outlook, and Word. I developed in Access for about 7 years and Access forms and reports allowed me to fulfill all end-users requirements, but you can try SQL Server Reporting Services...
user's latest post:
Put all my eggs in one basket,...
Published (2009-11-20 10:19:00)
if it is down, everything is down(all clients data will be down) in centralised approach some sort of decentralisation is required
user's latest post:
Using Query Graphical Tool Then...
Published (2009-11-27 07:22:00)
Hi, There is a resolution from Microsoft Connect: ---------------------------------------------------- The requested feature already exists in SQL Server 2005 and 2008. I see the information is already provided in this thread. In SSMS there are two options for Query Editor. 1) Global Tools option that sets preferences for entire QE sessions. 2) Session option that sets preferences only for the current QE session; this is a subset of Global...
user's latest post:
I am getting an error with the...
Published (2009-11-20 18:17:00)
okay i've read: To correct this error Check to see if two different statements have inadvertently been put on the same line. Insert a line terminator after the element that completes the statement. does the line terminator refer to the semi-colon (;) when talking about line termination? i'll try this in a couple hours and let you know. thanx
user's latest post:
How do I store a file path as a...
Published (2009-11-25 02:27:00)
Hi Jim, Lekss. Thank you for your help. I just wanted to be sure I didn't overlook anything. Storing the file path is not a problem. Sincerely, Rupertsland, Canada
|
|
|
|
Latest active threads on Getting started with SQL Server::
Started 5 days, 11 hours ago (2009-11-24 15:17:00)
by Eric Wisdahl
If you have not taken any of the exams and are planning on working with SQL in the future, I would forgo the SQL 2005 certificates and concentrate on the SQL 2008.
Started 3 days, 20 hours ago (2009-11-26 06:17:00)
by SQLUSA
Peter, You can store Word documents in a varbinary(max) column. You are responsible for visualization though, it is just stored as BLOB in the database. Related thread: http://social.msdn.microsoft.com/forums/en-US/sqld atabaseengine/thread/a91e4a05-25b2-449a-9d51-08e54 fef702c/ Related article: Store and retrieve objects as BLOBs in SQL Server 2000 and 2005 using ASP.NET 2.0
Started 3 days, 8 hours ago (2009-11-26 18:02:00)
by tp99
Hi Everyone, Hoping someone can assist me with this question. We have an Access DB that was originally created with Access 2003, and then was recently converted to work with Access 2007. We are now in the process of preparing to migrate the Access 2007 DB to a SQL Server Standard 2008 server DB. This will be a brand new SQL Server DB. The current desktop operating system is windows XP SP3...
Started 2 days, 7 hours ago (2009-11-27 19:09:00)
by Sankar Reddy
>>In which table? Try below query.
SELECT
SUBSTRING ( dest.text, (der.statement_start_offset/2)+1,
(( CASE der.statement_end_offset
WHEN -1 THEN DATALENGTH (dest.text)
ELSE der.statement_end_offset
END - der.statement_start_offset)/2) + 1) AS statement_text
FROM sys.dm_exec_requests AS der cross apply
sys.dm_exec_...
Started 2 days, 11 hours ago (2009-11-27 15:48:00)
by SQLUSA
False! An email scam. Links: http://www.microsoft.com/communities/newsgroups/en -us/default.aspx?dg=microsoft. public.news.server&t id=75cec085-4c25-4715-b8aa-3588d92d5cbe&cat=en_US_ 9b6d26c4-de58-4d72-93d9-4c56f036b989&lang=en&cr=US &sloc=&p=1 http://www.complaintsboard.com/complaints/microsof t-award-team-baley-house-har-road-sutton-greater-l ondon-sm1-4te-united-a-kingdom-c167975.html http...
Started 1 week, 2 days ago (2009-11-20 16:19:00)
by Chirag_Shah
SQL Server integration services can do this for you. You will need to create an SSIS package and have it scheduled to run as a SQL server agent job. This is by far the the best option if you want to run it periodically.
You can also use SQL Server import export wizard.
If want to use T-SQL then create a linked server pointing to your visual fox pro
And ...
Started 2 days, 11 hours ago (2009-11-27 15:06:00)
by Vincent Rainardi
I experience the same error message: Message: Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) When: this message appear when I tried to open an SSMS solution. In this case it's a SQL Script solution (relational). Env: XP SP3, SQL 2k8 RTM Background: A few days ago I uninstalled a lot of VS2005 stuff and SQL2005 stuff ...
Started 2 days, 15 hours ago (2009-11-27 11:00:00)
by Deepak Rangarajan
Babu, There is no hard and fast rule while performance tuning. I have seen cases where CTE seems to perform badly and I changed the code to derived table, which performed well. So I would recommend you to test your code and see running profiler. Check the reads , enable STATISTICS IO and see the number of physical and logical reads and see which one performs better. I've seen CTE mainly ...
Started 4 days, 5 hours ago (2009-11-25 21:01:00)
by Sankar Reddy
It should come up and it works correctly for me. Although I am using SQL Server SP2 and SP3. Go to SSMS | Help | About and look for the Microsoft SQL Server Management Studio. Some utilities like this will work starting from SP2 although I can't speak with authority on this one. Download SP2.
|
|
Hot threads for last week on Getting started with SQL Server::
Started 3 days, 5 hours ago (2009-11-26 21:09:00)
by Lekss
You can do it this way. Here for every new user the ID is automatically incremented to the next integer. create table schemaname . tablename
( ID int not null identity ( 1 , 1 ), username varchar ( 50 ), [password] varchar ( 50 ) )
Thanks, Leks
Started 5 days, 19 hours ago (2009-11-24 07:46:00)
by Yatao
the value of skills cannot equals to 'Middle East' AND 'Resident Engineer' at the same time. I guess what you need could be AND (skills = 'Middle East' OR skills = 'Resident Engineer' )
Started 4 days, 14 hours ago (2009-11-25 12:08:00)
by Sean Gallardy
Could you please post the error message returned?
Started 5 days, 18 hours ago (2009-11-24 08:44:00)
by Melissa Suciadi
declare @table table (SnoID int , Sname varchar (20), SAddress varchar (20), Srace varchar (10), Sitem Varchar (20))
insert into @table (SnoID, SName, SAddress, SRace,SItem)
select 1, 'Abs' , 'AA' , 'Hindu' , 'A' UNION ALL
select 1, 'Abs' , 'AA' , 'Hindu' , 'A' UNION ALL
select 1, 'Abs' , 'AA' , 'Hindu' , 'A' UNION ALL
select 2, 'Abs' , ...
Started 5 days, 1 hour ago (2009-11-25 01:22:00)
by Lekss
Where did you attach / install those database ie. to which SQL server instance?
You need a SQL instance to attach those DBs and then connect to the server instance using SSMS.
Started 6 days, 14 hours ago (2009-11-23 12:54:00)
by spydaios
I have my local DB say "HD" on my machine and remote server say "RM-S/2005" has DB "R-DB", in R-DB there is scalar valued function "Function1(EmpId)" In my local DB i need to create a view using Function1(Empid) view is say , "view_ProjAccToEmployee" as follows,
SELECT A.ProjectID, A.ProjectName,
[RM-S/2005].[R-DB].dbo.Function1(B.EmployeeID) AS EmployeeId
FROM...
Started 3 days, 8 hours ago (2009-11-26 18:02:00)
by tp99
Hi Everyone, Hoping someone can assist me with this question. We have an Access DB that was originally created with Access 2003, and then was recently converted to work with Access 2007. We are now in the process of preparing to migrate the Access 2007 DB to a SQL Server Standard 2008 server DB. This will be a brand new SQL Server DB. The current desktop operating system is windows XP SP3...
Started 5 days, 12 hours ago (2009-11-24 14:49:00)
by Chirag_Shah
SQL Server product manual is called “Books Online” and it provides a great help
Link to Download
You can also find a set of videos that describe basic usage at http://www.microsoft.com/sql/editions/express/lear nvideos.mspx .
Again, these were generated for 2005, but they cover basic concepts of database functionality so they apply equally to 2008.
There are also webcasts ...
Started 5 days, 14 hours ago (2009-11-24 12:55:00)
by SQLUSA
No limitation or restrictions whatsoever with Microsoft SQl Server 2005 Developer Edition. Only licensing limitation: development only , no production.
Started 4 days, 5 hours ago (2009-11-25 21:01:00)
by Sankar Reddy
It should come up and it works correctly for me. Although I am using SQL Server SP2 and SP3. Go to SSMS | Help | About and look for the Microsoft SQL Server Management Studio. Some utilities like this will work starting from SP2 although I can't speak with authority on this one. Download SP2.
|
|
Size: 188 bytes
