Viewing 15 posts - 706 through 720 (of 1,162 total)
Yes, it means the SQL Server Service Account
July 29, 2011 at 10:02 am
Depends slightly on versions, amount of memory and architecture (32 vs64-bit), but the following articles should help:
July 29, 2011 at 7:37 am
Ninja's_RGR'us (7/29/2011)
Got a solid link about this Howard? I'd love to get more info on the topic.
About performance issues with SQL Server and Paging, SQL Server Memory Management or...
July 29, 2011 at 7:27 am
aurato (7/29/2011)
July 29, 2011 at 7:09 am
It's recreated from Model, not Master.
The area I would be looking at is the disk subsystem. Do you run anything like Diskeeper, or run on virtual infrastructure that could block...
July 29, 2011 at 6:49 am
There are some minor differences, but they fundamentally do the same thing (at least for auto increment in mySQL)...
July 28, 2011 at 7:08 am
To avoid a compile time error, you'd have to execute it dynamically E.g.:
BEGIN TRY
DECLARE @sql VARCHAR (8000)
SET @sql='INSERT INTO table2 SELECT * FROM table1'
EXEC(@sql)
END TRY
BEGIN CATCH
print 'There was an error:...
July 22, 2011 at 6:22 am
Bruce W Cassidy (6/29/2011)
Oracle's usernames and passwords are case insensitive, btw.
eh? Usernames are, passwords are not as with most implementations
June 30, 2011 at 1:55 am
Do you want to elaborate on that Muthukkumaran?
George, what percentage of the database is in use? If there's no extra storage available and you must do it, you may...
June 24, 2011 at 3:05 am
SQLRNNR (6/21/2011)
opc.three (6/21/2011)
Grant Fritchey (6/21/2011)
Sumanta Roy (6/21/2011)
As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity...
June 21, 2011 at 8:27 am
Link to the specific part of the documentation that describes the behaviour:
http://msdn.microsoft.com/en-us/library/ms181151.aspx
Indexed views can be created in any edition of SQL Server. In SQL Server Enterprise, the query optimizer automatically...
June 21, 2011 at 7:02 am
Ninja's_RGR'us (6/21/2011)
HowardW (6/21/2011)
LutzM (6/21/2011)
In SS2K it's possible to control the order of the rows returned via ORDER BY in the...
June 21, 2011 at 6:28 am
LutzM (6/21/2011)
In SS2K it's possible to control the order of the rows returned via ORDER BY in the view definition.
SS2K8...
June 21, 2011 at 6:08 am
You may want to try adding in some GO statements every 1000 lines or so - this is the batch terminator in SQLCMD and SSMS. Otherwise it's trying to submit...
June 14, 2011 at 5:48 am
I'd recommend bugging MS on:
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=474589
The KB seems rather light on documentation for which version's/CU's it's fixed in
June 13, 2011 at 5:56 am
Viewing 15 posts - 706 through 720 (of 1,162 total)