Viewing 15 posts - 361 through 375 (of 431 total)
In Estimated Execution Plan I'm showing 0 cost for both methods, and Client Statistics shows both methods with virtually the same Client Execution Time.
How do you determine which is more...
July 6, 2012 at 4:09 pm
Not sure if this is what you need or not but this prodedure assumes that your fiscal year begins on October 1 and will provide the last date of the...
July 6, 2012 at 3:40 pm
As with anything, "It depends."
I'm working toward attempt #2 at 70-432 myself. As for what's next, I'm considering
1) What will help me do my current job better?...
July 6, 2012 at 11:46 am
How about create procedure sp_lastdayofyear (@year int) as
select Convert(date,convert(varchar(4),@year)+'-12-31')
July 6, 2012 at 10:31 am
I don't recall any female Jedi Knights. What's up with that Lucas? Alas, that is a debate for another forum.
July 5, 2012 at 4:43 pm
I run the Service Pack installs on any machine that has components of SQL Server, including workstations with Management Studio. The SP installer will upgrade whatever SQL components...
July 5, 2012 at 3:06 pm
What operating system did you install on? SQL 2005 Standard & Enterprise Database Engine will not install on Windows 7, Vista or XP, but some of the...
July 5, 2012 at 3:02 pm
When writing UPDATE or DELETE statements in Management Studio, always have a BEGIN TRAN in front of it.
This has saved my butt more than once, on occasions I expected to...
July 5, 2012 at 10:39 am
Nicholas,
Just curious, what are the specs on your laptop & VMs? I've thought about clustering VMs on my home computer for self-training purposes, but I'm concerned about maxing...
July 3, 2012 at 9:43 am
How much of a factor is database size? If instance1 has 1 user database less than 1GB and instance2 has multiple DBs totalling 100 GB I can't imagine...
July 2, 2012 at 2:38 pm
According to my Exam Study Guide OPENROWSET is discouraged because it presents security risks. Linked Servers is more secure.
June 29, 2012 at 4:42 pm
Related question: Is leaving the default memory settings in place sometimes better, or is it always better to manually configure the memory settings?
If a server hosts a single instance of...
June 29, 2012 at 10:37 am
This is correct - you have 1 instance.
I ran into this confusion recently. On my home computer I have an instance of SQL2008 R2 Express I installed some...
June 27, 2012 at 12:40 pm
Folks, I did some reading and dug a little deeper, but I need the advice of a SQL/SSRS guru before moving further. I ran DBCC OPENTRAN on ReportServerTempDB and...
June 21, 2012 at 12:59 pm
You don't need to reboot the server as a last resort to shrink the tempDB. You can shut off & turn on the SQL Server service in Configuration...
June 20, 2012 at 3:16 pm
Viewing 15 posts - 361 through 375 (of 431 total)