Viewing 15 posts - 7,306 through 7,320 (of 22,213 total)
You could try SQL Search[/url] from Red Gate. It's a free tool that should find those references pretty easily.
Mandatory disclaimer (although I'm not sure why for a free tool): I...
October 23, 2014 at 4:12 am
Glad you solved it and thanks or posting the follow up. It's always good to know what the problem really was and the solution.
October 23, 2014 at 1:18 am
Edited it. Not sure where my brain was.
October 22, 2014 at 10:35 am
patrickmcginnis59 10839 (10/22/2014)
Those are the fundamental building blocks of relational databases. A primary key uniquely identifies a row within the database an individual table....
October 22, 2014 at 10:35 am
Where it says "relational databases" is a link. There is another at "primary key" and "foreign key" in the second paragraph.
October 22, 2014 at 10:28 am
You're hard coding the value as 4. Within a script as you've outlined, you'd have to change the value to 5, 6 or 7 to get those values. If you...
October 22, 2014 at 9:56 am
I also agree with Spaghetti on this one. Your approach will work. It's just not very clear. A lack of clarity can absolutely lead to error. For example, with only...
October 22, 2014 at 9:47 am
Those are the fundamental building blocks of relational databases. A primary key uniquely identifies a row within a table. A foreign key is used to relate one table to another,...
October 22, 2014 at 9:44 am
There is no specific to SQL Server function called a "refresh." Most of the time I've seen it used it's referring to a process (created by a business) wherein an...
October 22, 2014 at 9:25 am
That's really odd that the 120 compatibility level would do this. Have you applied any of the CUs?
October 22, 2014 at 9:21 am
My first thoughts were around parameter sniffing and issues there, especially if you're seeing changes in behavior based on changing the cardinality estimator (changing the compatibility level). But, I'm also...
October 22, 2014 at 5:48 am
Put your database code into source control and start treating it, as much as possible, like your application code. But, if you really want to start talking about database deployment...
October 22, 2014 at 1:14 am
Take a look at what Kendal Van Dyke has been working on, it might help.
October 22, 2014 at 1:11 am
October 22, 2014 at 1:10 am
That's pretty small data growth. Check the execution plans for the query from the old database as compared to the new one. See if they're different.
October 21, 2014 at 6:16 am
Viewing 15 posts - 7,306 through 7,320 (of 22,213 total)