Viewing 15 posts - 42,916 through 42,930 (of 49,552 total)
Create the table, then do an insert into... select ... with that query as the select. If you want it to refresh ever day, then you'll need to set up...
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
November 26, 2008 at 2:01 pm
It doesn't add builtin\administrators. It adds windows accounts that you specify to SQL server and makes them sysadmin. There's no good reason not to run it.
If your server is set...
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
November 26, 2008 at 1:54 pm
Adam Bean (11/26/2008)
Why oh why is this not working!
I'll be blunt. That form of query does not and can not perform well. Regardless of indexes, order of bits in 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
November 26, 2008 at 1:48 pm
I also took very few photos. I checked my camera this afternoon and realised that I took just 1 photo during the 3 main days. 🙁
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
November 26, 2008 at 1:36 pm
nate (11/26/2008)
Gail, the quick response is much appreciated. Also, nice presentation at PASS 2008.
Oh, thanks.
The primary key is actually non-clustered, and I'm trying to delete a clustered...
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
November 26, 2008 at 1:26 pm
Benjamin Lotter (11/26/2008)
By default, when you install SQL, it adds the group "BUILTIN\Administrators" to the SQL Server with the sysadmin server role.
Not on Vista or Server 2008. On those...
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
November 26, 2008 at 1:23 pm
The primary key is enforced by an index and, I'd guess from your description that the primary key is the clustered index (use sp_helpindex to check). You can't drop 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
November 26, 2008 at 1:16 pm
Trace does show before execution. That's what the StmtStarting and SPStarting events are. The StmtCompleted and SPCompleted are the events that fire after execution. It's not going to let you...
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
November 26, 2008 at 1:07 pm
Thread continues here: http://www.sqlservercentral.com/Forums/FindPost609378.aspx
Marin: It's better to continue posting on a single thread than to start a new one. That way the people helping you can see when new posts...
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
November 26, 2008 at 12:43 pm
For the sample data that you've posted, what's the output that you want? What records do you want back?
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
November 26, 2008 at 12:32 pm
You can use profiler and catch the statement/sp starting events. Not sure if it's the right solution though.
What's the reason behind the question? What are you trying to do with...
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
November 26, 2008 at 12:31 pm
Garadin (11/26/2008)
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
November 26, 2008 at 12:27 pm
kotlas7 (11/26/2008)
But One thing still confusing me..In BOL, they mentioned tail backup is introduced in SQL Server 2005. But it also working in sql server 2000.
No, they don't...
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
November 26, 2008 at 12:17 pm
What does the query for the report look like? Can you do the calculation 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
November 26, 2008 at 12:07 pm
Ok, I've never actually tried running both. Isn't needed. If what you want is to take a log backup and switch the DB into recovery to prevent more changes before...
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
November 26, 2008 at 12:05 pm
Viewing 15 posts - 42,916 through 42,930 (of 49,552 total)