Viewing 15 posts - 31 through 45 (of 69 total)
bruce-347665 (10/18/2012)
Can I install the trial edition and update-it to standard edition after I...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 18, 2012 at 7:55 am
What's all this Application Name=SSIS-Gather_Server_and_Database_Information-{30870F9F-B4A8-4EFF-B6C9-0C2DFB43480E} nonsense?!
Application Name is just an attribute that is part of the Connection String to SQL Server protocol which identifies the application that is connected to...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 18, 2012 at 4:16 am
I think an easy options is to Pivot using the UNPIVOT statement
This will transpose your Account1, Account2 columns into one column called "AccountType", then you can do a join on...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 11, 2012 at 8:18 am
venkat.2829 (10/11/2012)
I am reading below XML through T-SQL query, please see below and suggest me the solution
DECLARE @xmlAttributeRelation XML
SET @xmlAttributeRelation='<Entity>
...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 11, 2012 at 5:08 am
bruce-347665 (10/8/2012)
Can I use in a test environment the SQL Developer edition?To the test development will have access me (the developer) and some users for testing of application pourpose
I...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 5:36 pm
Bobby Glover (10/8/2012)
SQL 2008 (10.0.2351)Not R2
Quoting from the article:
"Up until the version of SMO that comes with SQL Server 2008 R2, the Size property of an instance of the DataFile...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 12:26 pm
emile.milne (10/8/2012)
When I go to shrink file,( I have...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 12:16 pm
Sean - I think the OUTPUT clause will return the rows, there is no SELECT.
blakmk - I think if you wrap up your transaction in a BEGIN and COMMIT, you...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 9:31 am
What happens if you force your query to use a particular index?
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 7:27 am
Have you tried with a fully qualified server name?
Something like <servername>.<localnetwork>.<tld>
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 7:17 am
Am not sure about your particular business requirements, but I can imagine this setup will be slower since you are introducing a new layer in your architecture, and also I...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 3:51 am
Hey,
I would recommend checking your EventViewer to see exactly why the instance is failing to start.
Here is a wee article[/url] that might help you diagnose the problem
If you post up...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 3:38 am
I've never tried this before, but you could potentially look at some of the sample code from Microsoft about how to load an RDLC from a Stream:
http://archive.msdn.microsoft.com/reportviewer
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 8, 2012 at 3:26 am
No problem. Looking forward to part 2 😉
Me too, great article for DAX beginners, particularly since it directly compares SQL format to DAX.
I would love to see some cross...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 3, 2012 at 11:32 am
I wonder if you can standardize this and ship it through something like CodePlex maybe as a 3rd party application.
I use a maintenance DB on all instances too, mostly to...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
July 31, 2012 at 8:34 am
Viewing 15 posts - 31 through 45 (of 69 total)