Viewing 15 posts - 91 through 105 (of 161 total)
Checkout the sys.dm_os_memory_xx dmv's - there should be something in there you're after.
April 7, 2012 at 9:57 am
could use something like this...?
SELECT TOP 1 c.cid
,c.cname
,COUNT(*) AS [Number_Of_Students]
FROM course c
INNER JOIN enroll e
ON c.cid = e.cid
GROUP BY c.cid, c.cname
ORDER BY Number_Of_Students DESC
the problem with this...
April 2, 2012 at 3:15 am
I believe there is a deprecated feature check. I can't remember if it is on the installation disk or not but one does exist - run that and it...
April 2, 2012 at 1:41 am
Gabe T. (3/12/2012)
For some QA of a project, I've been asked to generate some CSV files for a single day (i.e. not on a regular basis) that they would...
March 13, 2012 at 4:18 am
Eugene Elutin (3/1/2012)
Loundy (3/1/2012)
If i'm not mistaken (someone...
March 1, 2012 at 4:04 am
I've yet to find a use for triggers if i'm honest (there will be some use for them in the future im sure)
If i'm not mistaken (someone will correct me...
March 1, 2012 at 3:53 am
Ok - so i tried the following and still nothing showing in CMS....
Imported a policy from within the cms which deployed fine to all registered servers
Thought it might be to...
February 28, 2012 at 10:24 am
This is a duplicate post - i've reposted this in the general forum - please do not reply to this thread.
Sorry 🙂
February 28, 2012 at 6:37 am
lucchesediego (2/27/2012)
February 27, 2012 at 3:33 am
Full text Indexing perhaps?
http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server
February 27, 2012 at 1:45 am
Grant Fritchey (2/24/2012)
Loundy (2/24/2012)
sqlzealot-81 (2/23/2012)
Try re-registering TextMgrP.dll.
This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"
Also, If you have a 3rd party IntelliSense...
February 24, 2012 at 5:39 am
sqlzealot-81 (2/24/2012)
Hi Experts,Any one has any idea about "PREEMPTIVE_OS_REVERTTOSELF" wait type. Appreciate any heads up..
wait types:
February 24, 2012 at 5:38 am
Gianluca Sartori (2/24/2012)
-- CREATE A TABLE FOR TESTING
CREATE TABLE testTab (
cd varchar(max),
someColumn varchar(max)
)
GO
-- INSERT SOME TEST...
February 24, 2012 at 4:51 am
sqlzealot-81 (2/23/2012)
Try re-registering TextMgrP.dll.
This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"
Also, If you have a 3rd party IntelliSense installed (such as...
February 24, 2012 at 2:25 am
anthony.green (2/24/2012)
sp_msforeachdb 'USE [?];select
DatabaseName = DB_NAME() ,
CollectionDate = CONVERT(DATE,GETDATE()),
a.FILEID,
[FILE_SIZE_MB] =
convert(decimal(12,2),round(a.size/128.000,2)),
[SPACE_USED_MB] =
convert(decimal(12,2),round(fileproperty(a.name,''SpaceUsed'')/128.000,2)),
[FREE_SPACE_MB] =
convert(decimal(12,2),round((a.size-fileproperty(a.name,''SpaceUsed''))/128.000,2)) ,
a.NAME,
a.FILENAME
from
dbo.sysfiles a'
This is a nice script bud - cheers for this 🙂
February 24, 2012 at 2:12 am
Viewing 15 posts - 91 through 105 (of 161 total)