Viewing 15 posts - 46,921 through 46,935 (of 49,552 total)
If the database is in simple recovery mode (which it is) that option will have no effect. It's a older way of doing exactly what simple recovery mode does.
Also, that...
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
April 11, 2008 at 5:02 am
CPU or memory? (Title says one, post says the other)
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
April 11, 2008 at 3:38 am
Books online is your friend.
Here's an simplified version of a sample query from the help page on sys.dm_exec_sql_text
SELECT s2.dbid,
s1.sql_handle,
s2.text...
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
April 11, 2008 at 12:45 am
GSquared (4/10/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
April 11, 2008 at 12:34 am
If you install the SQL Server workstation components, you'll ge BI development studio. It's Visual studio, with the BI projects in it. No need to download anything.
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
April 11, 2008 at 12:25 am
escaleraroyal (4/10/2008)
which one is faster?2Gig CPU + 15.4GB ram
or
3.06Gig CPU + 7.75GB ram
Faster for what?
What size DB do you have? OLTP or Datawarehouse style usage
How many concurrent users?
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
April 11, 2008 at 12:16 am
System processes (spid < 51) or user processes?
Are you running SQL with the windows fibres enabled?
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
April 11, 2008 at 12:03 am
What exactly do you mean by 'doesn't work'?
Very slow?
Errors?
???
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
April 11, 2008 at 12:01 am
shwetha004 (4/8/2008)
Public cn as New ADODB.Connection
Dim connStr as String
connStr ="";//i have checked that the connection string points to the correct database.
cn.Open connStr
cn.Execute sqlStatement//the program hangs at this line of code
What's...
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
April 10, 2008 at 11:59 pm
Sounds like there might be some permissions problems somewhere.
Do you know what account SQL Express is running as? (SQL Server configuration manager will show you that)
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
April 10, 2008 at 11:52 pm
At my current place we start with the technical interview. Since we're curently looking for people to do performance tuning and monitoring, I'll usually start with a very simple question...
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
April 10, 2008 at 6:29 am
It might. It's worth trying, though there are a lot of possible reasons for recompiles.
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
April 10, 2008 at 6:02 am
laker_42 (4/10/2008)
As Gilamonstor stated, if you are only using 4gb, you don't need to use AWE or the switches. Just set your min & max memory levels for SQL:
That's...
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
April 10, 2008 at 5:13 am
If you convert the query into a stored proc and change all the front end calls to reference that proc yes it will help.
I would also suggst that you change...
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
April 10, 2008 at 4:47 am
There's no such thing as a stupid question.... 😀
The order of your statements is fine. The problem is your exists statement
If not exists(select * from IPPxCdr where name = 'Users')
I'm...
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
April 10, 2008 at 4:43 am
Viewing 15 posts - 46,921 through 46,935 (of 49,552 total)