Viewing 15 posts - 43,741 through 43,755 (of 49,571 total)
At a very high level, parse, bind, optimise, process.
First the parser takes the SQL code, makes sure there are no syntax errors and then converts it into a tree-like...
October 16, 2008 at 1:42 am
No, the if-else will not cause a recompile.
When SQL compiles the procedure the first time, it will compile and optimise all of the queries in the procedure. Even ones in...
October 16, 2008 at 1:40 am
There's a big, big difference between SQL's internal caches (which is what Kishore and I were talking about) and client-side caching
What front end language are you using?
You may get better...
October 16, 2008 at 1:30 am
oraculum (10/15/2008)
SOS_SCHEDULER_YIELD is the another prominent wait event that shows up...
What others show hight wait times?
October 16, 2008 at 1:27 am
williamminor (10/15/2008)
I'm on the correct machine. I change the command prombpt over to d and ran the sqlservr.exe - fand got the same message as the previous one
Are you working...
October 16, 2008 at 1:16 am
Just to check, you are running that on the server?
Find where the exec is. I don't know your dir structure. Something like this
C:\Program Files\SQL Server\MSSQL\MSSQL\Binn
Change to that dir and you...
October 15, 2008 at 4:19 pm
I'm going to have to leave it here, it's past midnight. I'm sure someone wlse will be able to help.
Once you get SQL running from the the command line,...
October 15, 2008 at 4:12 pm
What files are there in the E:\Program Files\Microsoft SQL Server\MSSQL\data\ directory?
Open a command prompt. (not the run dialog)
type
sqlservr.exe -f
If it gives an error or anything else strange, post the...
October 15, 2008 at 3:33 pm
And what are the names of the tempDB data and log files in the E:\Program Files\Microsoft SQL Server\MSSQL\data\ directory?
Can you shut the service down and bring SQL up from...
October 15, 2008 at 3:15 pm
Ok, so what does the 2000 equivalent return?
select * from master..sysaltfiles where dbid = 2
Please in future post SQL 2000 questions in the 2000 forums. If they're in the 2005...
October 15, 2008 at 3:12 pm
What does the following return?
select * from sys.master_files where database_id = 2
October 15, 2008 at 3:07 pm
Look up the UNPIVOT command in books online. I think it should do exactly what you're after.
October 15, 2008 at 2:56 pm
What syntax?
1) Is the server running?
2) Are there any errors in the error log? (if you've not sure, post the entire thing)
October 15, 2008 at 2:55 pm
Lynn Pettis (10/15/2008)
Here's an answer you might hear where I work:The SAN will never go down.
Yeah, right. Sure it won't. <sigh>
I actually have seen a SAN go down. Not only...
October 15, 2008 at 2:49 pm
You can't update the system tables on 2005, and you shouldn't try anyway. It's the quickest way to really stuff things up.
Can you post any errors from the error log...
October 15, 2008 at 2:32 pm
Viewing 15 posts - 43,741 through 43,755 (of 49,571 total)