Viewing 15 posts - 42,301 through 42,315 (of 49,552 total)
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2008 at 12:56 pm
kwitzell (12/17/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2008 at 9:21 am
Grant Fritchey (12/17/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2008 at 8:51 am
Or is the data in one table in a database on the reporting server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2008 at 8:47 am
Also, can you post the full table definition, including data types and constraints (if any)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2008 at 12:22 am
Viewing 15 posts - 42,301 through 42,315 (of 49,552 total)