Viewing 15 posts - 11,716 through 11,730 (of 49,552 total)
SELECT INTO cannot specify a filegroup. The created table will be created on the default filegroup. If you want something else, you have to use the full, explicit CREATE TABLE...
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
September 12, 2013 at 8:13 am
Restoring a backup of a database and running CheckDB on the restored backup is a perfectly acceptable way of doing integrity checks. The only problem with it is the potential...
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
September 12, 2013 at 8:11 am
You never block yourself. If you have just run a data modification, in that same session you can always see the data you modified.
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
September 12, 2013 at 1:07 am
gary1 (9/11/2013)
By design, SQL Sever should use all of its max memory right?
As I said above, no. There is no guarantee that SQL will use max server memory, it's just...
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
September 12, 2013 at 12:55 am
Max server memory is just the upper limit that SQL is allowed to use. There's many cases where it won't reach that. Ones that immediately come to mind is it...
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
September 11, 2013 at 5:22 pm
Not EXECUTE AS CALLER. EXECUTE AS and specify an explicit login that has insert permissions on the audit table, then you don't need permissions to public.
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
September 11, 2013 at 5:19 pm
The way I usually recommend is to use impersonation on the trigger.
CREATE TRIGGER ...
WITH EXECUTE AS ....
And execute it as a login that has insert permissions into that audit table....
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
September 11, 2013 at 4:47 pm
So you're looking for some scheduled windows script that's running against your databases. I would look first at Windows Scheduler, see what's in there.
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
September 11, 2013 at 4:30 pm
Depends on the query, but TOP adds a row goal to the query which could result in the row estimations being wrong (the row goal gets used instead of the...
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
September 11, 2013 at 12:57 pm
Something running as the local system is trying to log into your server and access the databases. Could be a service running as SYSTEM, could be an application, but the...
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
September 11, 2013 at 12:56 pm
Grant Fritchey (9/11/2013)
Disable the 'sa' login completely and rely on AD logins to manage all the servers.
This.
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
September 11, 2013 at 12:47 pm
That output is truncated.
I wasn't saying you truncated it. I'm saying that the package output, as shown in the job step history, is truncated. It's cut off when it'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
September 11, 2013 at 7:39 am
I mean exactly that. The output that you are looking at (that you've been posting) is truncated (cut off)
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
September 10, 2013 at 12:48 pm
Architecture of what? What are you looking for information on?
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
September 10, 2013 at 12:47 pm
All you're seeing there is truncated output.
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
September 10, 2013 at 9:52 am
Viewing 15 posts - 11,716 through 11,730 (of 49,552 total)