I set up a workload group with a resource pool associated who limits cpu usage to 30 % in a sql 2008 r2 environment.
When I start now 1 session in...
Just set up a Win 2008 ent. sp2 server with sql 2008 r2 ent. with large pages on and traceflag -T834 set. Server has 32 GB RAM, SQL instance...
Yes I am sure
Hmm, no, my installation os and sql server 2008 r2 is x64 ????
Removed instant client and installed x86 client (user defined, odbc, oledb + odbc 4 .net) added TNS_ADMIN variable and all works like a charme...
Want to import data from oracle to sql server 2008 r2.
Therefor I installed oracle instance client (11gr2 x64) on the server.
How to find out with profiler what rights are missing for e specific user?
What kind of events do I have to trace ?
I granted a Domaingroup rights in a DB.
If users from this AD group try to connect they geting the above mentioned error.
(Login failed for...
Does the server (not the client) ever closes a connection to a client cause of inactive session (timeout) ?
We have a central db setup with more applications sharing one instance.
Each application has its one db(s) and AD groups allowing access only...
I have users reporting an error in a application not beeing able to update a specific vaule in a table.
Running a trace gives me the...
Not every day, ~ once e week we set up new db's
Windows 2008 Server Enterprise x64 sp2
SQL Server 2008 Enterprise x64 SP1 (10.0.2531.0)
On the directories where the Data- (F:.....Data) and the Logfiles (G:....Log) are stored we set up our own access rights (with downward...
If I have the following backup scenario:
DECLARE @Table0 TABLE ( Field1 ... )
INSERT INTO @Table0
SELECT FROM Permanent_Table0...
DECLARE @Table1 TABLE( Field1 ...)
sizes for the temporary tables are:
9 rows, 0.008 MB
2860 rows, 0.345 MB
10100 rows, 0.133 MB
lines where temporary tables have been replaced with 'real' tables are ---
Sorry no, does not work.
Is there a limit with the size of a post in this forum ???
Hi all,Have a stored proc that creates three tables and uses these tables in a select within the same sp.
If I create these tables in my db the sp...
Separate names with a comma.