Viewing 15 posts - 15,796 through 15,810 (of 39,970 total)
The thing is we can't see you data. Can you post something that builds a table and populates it with sample data?
Something like
Create tableA
( ID int
, ColA varchar(10)
)
go
insert TableA...
June 27, 2011 at 10:04 am
Varies quite a bit, suspect that people are just busy this week getting ready for your vacation.
June 27, 2011 at 9:15 am
this might help you: http://www.sqlservercentral.com/articles/powershell/73288/
Powershell is a command line environment with SQL 2008 and newer Windows OSes. You can invoke the command line and then execute scripts, similar to how...
June 27, 2011 at 9:04 am
Why don't you want to join with the calendar table? Do you somehow think this is more efficient? Likely it's not if you plan on running a series of calculations...
June 26, 2011 at 12:47 pm
you're not doing a join here.
Also, what do you mean by exclude some dates? Is there a reason you don't have these marked in your calendar table?
June 26, 2011 at 10:40 am
Follow Jim's advice, but as a few hints.
1. write a SELECT that calculates the data first. You can do this for all rows, joining with your table of days. Once...
June 26, 2011 at 9:31 am
You can modify Jonathan's script to check for logins that have a used in a specified database, or just make sure you manually add those logins. There isn't a way...
June 26, 2011 at 7:52 am
GilaMonster (6/25/2011)
Jim Murphy (6/24/2011)
GilaMonster (6/24/2011)
Brain overfull. Firehose-style class. So glad I have a short vacation after this.
Awesome. Some day, I'll enjoy it. You will blog about your experience...
June 25, 2011 at 4:33 pm
ark.trofman (6/24/2011)
June 25, 2011 at 4:30 pm
Tom.Thomson (5/18/2010)
June 25, 2011 at 4:28 pm
I posted a note and Jonathan Kehayias wrote this: http://www.sqlskills.com/blogs/jonathan/post/Creating-a-new-Login-on-Multiple-Servers-with-the-same-SID-using-Powershell.aspx
June 25, 2011 at 3:44 pm
I'd open a case with Microsoft. I've never heard of anything remotely like this with SQL Server that wasn't some programming mistake.
June 25, 2011 at 3:43 pm
True, you could need to match up SIDs with SQL logins.
Likely PowerShell could somehow run the script, take the ouput and pipe that in as a new batch for a...
June 24, 2011 at 5:30 pm
Doh!
Yep, Datediff needs a type and then the arguments: http://msdn.microsoft.com/en-us/library/ms189794.aspx
The CASE is here: http://msdn.microsoft.com/en-us/library/ms181765.aspx
basically you can use it in the SELECT or the WHERE clauses as
CASE WHEN xx then...
June 24, 2011 at 5:27 pm
I'd completely agree with Gail. Weekly isn't granular enough. I'd go with a better trace or logging.
June 24, 2011 at 5:13 pm
Viewing 15 posts - 15,796 through 15,810 (of 39,970 total)