Viewing 15 posts - 45,436 through 45,450 (of 49,571 total)
Yes, there is. You can use the xp_msver extended procedure. I'm not sure of the security requirements
exec xp_msver 'ProcessorCount'
July 28, 2008 at 3:49 am
Shrinking a full database is a little pointless.
Shrink releases unused space to the OS, if a database is full then there is no free space inside it, hence all shrink...
July 28, 2008 at 3:43 am
Why are you putting the SQL database onto users PCs? Shouldn't it be on a central server?
July 28, 2008 at 3:36 am
Harish (7/28/2008)
Your table need to get repaired. If possible then recreate your table. or just run checkDB or dbcc checktable option with repair
Never run a checkDB or CheckTable with any...
July 28, 2008 at 3:36 am
aj (7/27/2008)
Hi everyone!looping that query and for each record checking for a duplicate, and if its not, inserting it into my table.
If you're doing that in SQL, there's part...
July 28, 2008 at 3:34 am
Since you're doing daily summaries, I might suggest the date combined with a second column as the clustered index. Or I might not. It's hard to say without more info.
Could...
July 28, 2008 at 3:29 am
Why are you shrinking your databases in the first place? It is not something you should be doing on a regular basis. They will just grow again as soon as...
July 28, 2008 at 3:24 am
Sam Peascod (7/27/2008)
July 28, 2008 at 3:17 am
Please ask your DBA (who I assume has sysadmin permissions) to run the xp_cmdshell as requested earlier and see what results you get back.
With execute as 'sa'
Grant impersonate on user::'test'...
July 28, 2008 at 3:13 am
MrBaseball34 (7/27/2008)
July 28, 2008 at 3:12 am
Venkatesan Prabu (7/26/2008)
CPU time will show the amount of time (in milliseconds) taken to execute your query.
It shows the amount of CPU time spent while running the query. It's not...
July 27, 2008 at 12:00 pm
On SQL 2005, rather use sys.sql_modules. There's one row per proc/view now, rather than 1 per 4000 character chunk. Makes searching through the code a little easier.
Steve: Source Control?...
July 26, 2008 at 2:13 pm
My former company has a number of 64 bit servers, running windows 2003 or windows 2008 and SQL 2005 and they are rock solid. I would not recommend IA64, there...
July 26, 2008 at 10:33 am
Somebody would have dropped them. SQL doesn't drop objects by itself.
If it happened recently, you can check in the default trace to see if there's any info (default trace is...
July 26, 2008 at 10:24 am
Viewing 15 posts - 45,436 through 45,450 (of 49,571 total)