Viewing 15 posts - 15,931 through 15,945 (of 39,901 total)
Broken clocks are right twice a day. Let's see the Rocks get through a couple series and win them
June 10, 2011 at 10:55 am
Using an identity doesn't mean that you have a large number. You could calculate a column of the date + identity if needed.
Alternatively, why not just calculate the "next" number...
June 9, 2011 at 3:23 pm
By default, you have no permissions on an object, say a table called "Sales"
If I use GRANT, I add permissions for you to view sales.
If I then use REVOKE, I...
June 9, 2011 at 1:59 pm
Someone sent me this: http://scrubs.codeplex.com/
HTH
June 9, 2011 at 1:22 pm
I'd look at virtual file stats for the tempdb data file.
Quite a few posts here as well: http://blogs.msdn.com/b/sqlserverstorageengine/archive/tags/tempdb/
Ultimately it comes down to measuring how much the...
June 9, 2011 at 1:21 pm
GilaMonster (6/9/2011)
Steve Jones - SSC Editor (6/9/2011)
June 9, 2011 at 1:05 pm
I am not an expert on those tools, but from what I understand, those tools are more built to manage the server itself. They look at performance and activity, but...
June 9, 2011 at 1:04 pm
Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or discussion seemed to be of use to the site...
June 9, 2011 at 12:56 pm
Short way: grant new permissions first, then revoke old ones.
As mentioned above, you need to determine their permissions. You can use this to help: http://msdn.microsoft.com/en-us/library/ms176097.aspx
What you want to do...
June 9, 2011 at 12:54 pm
Stefan Krzywicki (6/9/2011)
The biggest surprise for me was when I had to have a headlight replaced. I went in to the dealership expecting the typical $20 (On other cars I...
June 9, 2011 at 12:42 pm
I don't know of anything that will tell you what is being used from an automated fashion. I suspect that you'd need something that combs through SSRS logs and tries...
June 9, 2011 at 12:38 pm
Just ran this:
C:\Users\Steve>bcp "select * from db1.dbo.mytable" queryout out.txt -C -T -t "|" -S sevenfalls
I didn't see a server name in yours.
June 9, 2011 at 12:30 pm
Haven't tested them together, but both have worked for me. I have been hesitant to use them without stopping SQL Server. Even then, make sure I have 2 backups, just...
June 9, 2011 at 12:26 pm
Not to make it more complicated, but where are backup files going? I'd make sure you have space somewhere separate from the data files.
Do you use tempdb a lot? If...
June 9, 2011 at 12:22 pm
The transfer task, if it's the same as 2005, just automates the object creation and then the transfer of data from one place to another.
It works, but you could potentially...
June 9, 2011 at 12:18 pm
Viewing 15 posts - 15,931 through 15,945 (of 39,901 total)