Viewing 15 posts - 7,201 through 7,215 (of 8,416 total)
luckysql.kinda (9/5/2009)
Oh I found. When sql server express edition is installed then sql server agent service is installed but this never runs. Dumb service is installed by Microsoft.-LK
I might have...
September 5, 2009 at 6:04 am
This just illustrates one more reason to prefer integrated authentication.
If I had a SQL Server login which was protected by the same strong password used for other things then I...
September 5, 2009 at 2:40 am
It would be interesting to know if the procedure is still slow when called with the WITH RECOMPILE option.
For example EXECUTE dbo.SuddenlySlowProc WITH RECOMPILE;
I suspect the SELECT INTO temp table...
September 5, 2009 at 2:00 am
That's right - Express does not include the SQL Job Agent.
Might the installed service belong to some other installed instance of some other edition of SQL Server?
Has the machine in...
September 5, 2009 at 1:43 am
dba-vb (9/5/2009)
hi,thx for ur replay. But why i'm getting this issue in same page like editurdetails.aspx.
thank you
Pradeep answered your question - the error seems to be caused by a fixed...
September 5, 2009 at 1:39 am
Jeff Moden (9/4/2009)
Going way back to the very first post on this thread, the answer is a resounding [font="Arial Black"]YES![/font]http://www.sqlservercentral.com/Forums/Topic783201-146-1.aspx?
That is impressive. I'd like to think he hit 'submit'...
September 5, 2009 at 1:19 am
sudhanva (9/4/2009)
Its like, if CountryPopulation column gets updated, i need to run a process in which, population of all the states will get updated,...
September 5, 2009 at 1:15 am
tvanharp (9/4/2009)
Thanks for the explanation. That is very helpful.
Thank you.
tvanharp (9/4/2009)
Would you ever make a NC index (in my case) with 35 included columns (essentially the whole table)?
I might. ...
September 5, 2009 at 1:04 am
I think Peter may be working his way through from post #1!
:laugh:
edit: "ORDER BY 1" :sick:
September 4, 2009 at 11:11 am
For everyone else's benefit: the first 8K page of the physical log file contains header information - no log records.
The header is just internal stuff to manage the log proper.
Paul
September 4, 2009 at 11:00 am
GilaMonster (9/4/2009)
Where is that info from?
Logs aren't divided into pages and they don't have allocation pages. They're divided internally into virtual log files (which do have headers) of varying sizes.
I...
September 4, 2009 at 10:48 am
tvanharp (9/2/2009)
Initially query was setup to select a couple columns and completed in about 7 seconds. The query used a non-clustered seek....
September 4, 2009 at 10:20 am
The thing about the log space used being slightly greater than the total size of the log is actually quite interesting.
Both DBCC SQLPERF and the performance counter method subtract header/allocation...
September 4, 2009 at 9:59 am
SELECT row_count = SUM(row_count)
FROM sys.dm_db_partition_stats DPS
WHERE DPS.[object_id] = OBJECT_ID(N'tempdb.dbo.[#AnyTempTable]', N'U')
AND DPS.index_id IN (0, 1);
sp_statistics requires you to specify 'E' for...
September 4, 2009 at 9:35 am
Judging from the screenshots, I imagine the issue is one of privacy, rather than how to upload a file.
Without an execution plan (or a crystal ball), I'm going to have...
September 4, 2009 at 9:20 am
Viewing 15 posts - 7,201 through 7,215 (of 8,416 total)