Viewing 15 posts - 39,106 through 39,120 (of 49,552 total)
There's no way to have separate diff 'streams' Even if you could use COPY_ONLY, it just means that the backup that you've taken doesn't reset the diff base. Any diffs...
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
May 14, 2009 at 6:07 am
Take a look at the sys.dm_exec_sessions and the sys.dm_exec_connections DMVs. You can use @@Spid to get the spid of the session to filter those DMVs.
Doing auditing in triggers?
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
May 14, 2009 at 5:13 am
No way to tell from that information.
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
May 14, 2009 at 5:03 am
SeanF (5/14/2009)
select count(column name) from tablewill return the number of non null columns
More correctly it will return the number of rows in the table where the column specified is not...
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
May 14, 2009 at 4:56 am
New database?
Existing database?
30 million concurrent users? If not, what's the estimate for concurrent users?
Expected database size?
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
May 14, 2009 at 4:55 am
No practical difference. They both count the number of rows in the resultset.
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
May 14, 2009 at 3:47 am
What do you mean by "redo a new database"? Restore from backup?
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
May 14, 2009 at 3:27 am
Those aren't errors. They're part of the normal restart-recovery of databases that SQL will do if the databases were not cleanly shut down when the SQL service terminated.
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
May 14, 2009 at 3:21 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
May 13, 2009 at 11:07 pm
A strong password is one that cannot be brute forced in a reasonable amount of time and is not vulnerable to a dictionary attack.
Bad password: P@$$w0rd
Reason: Those substitutions are common,...
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
May 13, 2009 at 11:06 pm
ComITSolutions (5/13/2009)
Yes, My application Stops Sql Server agent & SQl Server Takes Back-up(mdf and ldf files and starts SQL Server and Server Agent.
Don't. That's a very poor way to...
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
May 13, 2009 at 10:50 pm
Jacob Pressures (5/13/2009)
How much of that syntax do you guys know by heart without consulting a reference?
Quite a lot in areas that I work with frequently. When I can't remember...
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
May 13, 2009 at 3:19 pm
Clint (5/13/2009)
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
May 13, 2009 at 3:10 pm
ComITSolutions (5/12/2009)
When my application starts, Physical files back-up is taken(auto).
Do you mean that you just copy the database files (mdf and ldf) somewhere for a backup? Do you stop...
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
May 13, 2009 at 3:07 pm
Roger Abram (5/13/2009)
The data file has an MDF extension but the log file associated with it also has an MDF extension!!!
Doesn't matter. The extension doesn't set the type 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
May 13, 2009 at 3:02 pm
Viewing 15 posts - 39,106 through 39,120 (of 49,552 total)