Viewing 15 posts - 19,351 through 19,365 (of 22,213 total)
Something else is going on. All things being equal, a static set of data and a static set of code is going to return the same values. As others have...
October 29, 2008 at 5:44 am
Brackets are the way to go. If you used brackets within custom coding work in or around TSQL for anything other than naming database objects, you might be in trouble.
October 29, 2008 at 5:42 am
Does this mean I get to carry a gun at work now?
I promise, no more than one developer a week. 😀
October 29, 2008 at 5:32 am
Yeah, that's a pretty standard many-to-many relationship.
October 28, 2008 at 11:35 am
Take a look at sys.dm_db_index_physical_stats. That will give you quite a lot of information about the index, including the number of pages, density, space used, etc.
You can just look at...
October 28, 2008 at 8:29 am
ggraber (10/28/2008)
We are moving towards test-driven development and we are looking for a way to run...
October 28, 2008 at 8:23 am
Shaun McGuile (10/28/2008)
Thanks Grant.I was specifically talking about;
Database synch
Database Compare
Data Generator
Comparisons.
SQL Compare has quite a bit more functionality than the Schema Compare tool in VSTSDBE. But, the new version coming...
October 28, 2008 at 8:16 am
What if you changed those to OUTER JOINS within the main part of the FROM clause and then had something in the WHERE clause to only limit the data when...
October 28, 2008 at 8:02 am
Unless you're using a third party tool like HyperBac, you'll need to restore the entire database to a different location, either a second database on the server or a seperate...
October 28, 2008 at 6:30 am
Best way to do that is to use the OUTPUT clause.
From BOL:
USE AdventureWorks;
GO
DECLARE @MyTableVar table( ScrapReasonID smallint,
...
October 28, 2008 at 6:29 am
Totally different toolsets to a large degree. Actually I use both together. I do use SQL Compare & SQL Data Compare a little less than I used to, but I...
October 28, 2008 at 6:27 am
The costs are just estimates. Proof in the differences between the two plans will be in the compile and execution times, and the amount of I/O.
Several things about the queries...
October 28, 2008 at 5:45 am
You basically have it. TSQL isn't the best place to worry about formatting data. Convert is a pretty good method. But if you really need to break it down, take...
October 28, 2008 at 5:34 am
george sibbald (10/27/2008)
People have a problem, they do a search, a post from this site pops up, and voila there...
October 27, 2008 at 12:55 pm
Are you sure that it's not a view or a table valued function?
Is there an INSTEAD OF trigger on the table (if it is a table)?
October 27, 2008 at 11:41 am
Viewing 15 posts - 19,351 through 19,365 (of 22,213 total)