Topics
Started by
Posts
Last post
Environment: Windows Server 2003 SP2 4GB RAM SQL Server 2005 Workgroup Edition SP2 Issue: I have SQ…
10 replies
I have a query like this one : SELECT (fields_from_tables_and_views) FROM (some tables and views) W…
5 replies
Hi, I am currently monitoring a server and have discovered that SQL Server:Buffer Manager (Target P…
2 replies
Just beginning to dig into DMV's. Wondering if I can tie the query below to another DMV that will …
3 replies
I can check the size of a table with sp_spaceused. Can we check the size row wise ? May help me in …
2 replies
Hey guys, I'm trying to setup a trace to catch long running queries. Works fine, I get all the col…
8 replies
hello! i have a table valued function which has very low performance. SELECT * FROM MyFunction(Par…
24 replies
I read an article about having TEMPDB file group for each CPU.. We have 4 cpu on some servers but o…
46 replies
I have this simple query: SELECT Count('x') FROM PayeeMaster PM INNER JOIN PayeeLink PL (nolock) O…
25 replies
I have this simple query: SELECT Count('x') FROM PayeeMaster PM INNER JOIN PayeeLink PL (nolock) O…
1 replies
Hi, This is my first post here - I’m hoping someone can give me some advice. I've included the proc…
4 replies
So, recently I have been looking into executions plans and thanks to g.fritchey's book on executio…
7 replies
Hello, I have a Windows 2008 Server running a Sql Server 2005 SP4 and I don't know whats happening …
4 replies
I am having trouble getting this to return records quickly - SELECT Count('x') FROM PayeeMaster PM …
30 replies
I selected ‘Windows Authentication’ mode while installation. Can we make it ‘Mixed’ after installat…
3 replies
Viewing 15 topics - 511 through 525 (of 3,249 total)
You must be logged in to create new topics.