Viewing 15 posts - 42,316 through 42,330 (of 49,571 total)
I haven't seen this for a while.
is the set "SET CPU_ UTILISATION LOW" is the query to set the cpu utilisation low..
December 18, 2008 at 12:12 am
karthikaug18 (12/17/2008)
is the set "SET CPU_ UTILISATION LOW" is the query to set the cpu utilisation low..
Um, no. SQL will take what CPU it needs.
when we are taking the...
December 18, 2008 at 12:05 am
kwitzell (12/17/2008)
Gail,I ran the script and received no output (0 rows).
Ken
Is that in the AM20 database?
December 18, 2008 at 12:04 am
You gain points by posting (1 per post) or by answering the Question Of the Day correctly. Usually between 1 and 3 points
Forum Newbie - 0
Grasshopper - 10
SSC Rookie -...
December 17, 2008 at 1:25 pm
Since you're on 2005, join to sys.tables. Only user tables appear in that view.
sysobjects is deprecated in 2005 and above and will be removed in a future version.
December 17, 2008 at 12:59 pm
Grant Fritchey (12/17/2008)
Don't tell Steve, but there is a way to make BOL stay offline. You just have to mark it Local Only in the options.
That's always the first thing...
December 17, 2008 at 12:56 pm
kwitzell (12/17/2008)
December 17, 2008 at 12:54 pm
Jonathan Kehayias (12/17/2008)
Why can't I use a MessageBox.Show() in my Assembly.
<Blink> WT#@$#%$%^????????
To me that shows a fundamental lack of understanding of SQL, CLR within SQL or probably both.
December 17, 2008 at 9:40 am
Jose Ianuck (12/17/2008)
Recompile or SP_RECOMPILE, is the stored procedure that force a recompile of a stored procedure the next time it is run. ok!
Absolutely unnecessary. The reindex will force all...
December 17, 2008 at 9:33 am
Jack Corbett (12/17/2008)
I'm amazed at some of the problems people have with SQL Server and some of the requirements that they have to deal with.
I'm amazed by...
December 17, 2008 at 9:21 am
Grant Fritchey (12/17/2008)
December 17, 2008 at 8:51 am
Or is the data in one table in a database on the reporting server?
December 17, 2008 at 8:47 am
Also, can you post the full table definition, including data types and constraints (if any)
December 17, 2008 at 8:46 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
December 17, 2008 at 8:40 am
r.hensbergen (12/17/2008)
Do posters think we're answering bots instead of real people?
I suspect that some do, or think that we work for SSC. I recall someone apologising after I pointed...
December 17, 2008 at 8:37 am
Viewing 15 posts - 42,316 through 42,330 (of 49,571 total)