Viewing 15 posts - 42,316 through 42,330 (of 49,566 total)
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
Fraggle (12/17/2008)
Gail, are there any articles you would recommend on using server side traces?
Beyond Books Online, I'm not aware of any offhand. Google may be able to find tou some.
...
December 17, 2008 at 8:26 am
r.hensbergen (12/17/2008)
I think she said that customers expect that consultants are experts on every IT field.
Not quite what I meant. No one's going to hire me to fix...
December 17, 2008 at 8:05 am
ortek (12/17/2008)
It is this sort of statement that I find breath-taking in it's arrogance.
Which? That there's too much to learn and not enough weekends? That I don't...
December 17, 2008 at 7:52 am
Ok, some answers.
SP3 CU1 is a rollup of all the hotfixes that are in SP2 CU 10 and CU 11. They didn't make it into the service pack because they...
December 17, 2008 at 12:22 am
If you create the temp table in dynamic SQL, the temp table will go out of scope and be dropped as soon as the dynamic SQL ends. There's no way...
December 17, 2008 at 12:05 am
Viewing 15 posts - 42,316 through 42,330 (of 49,566 total)