Viewing 15 posts - 76 through 90 (of 205 total)
I originally tried the Begin End for both sides of the If Else, as it is my understanding that if you do not use them SQL will only execute one...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 28, 2011 at 8:46 am
Simplest way to do it.
I have to put together scripts to change data types or expand columns, depending on the business requirement. As part of the data type change, from...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
August 19, 2011 at 5:21 am
GilaMonster (8/18/2011)
Stamey (8/18/2011)
As I said, I have encountered people who think that the batching will have an effect on things like the transaction log, in that putting a Go in...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
August 18, 2011 at 1:49 pm
So, to take this a little further, Is there any advantage to example 2 over example 1, besides network communication (in fact example 2 would cause MORE network communication, right)?...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
August 18, 2011 at 7:36 am
Yeah, I know. I did find a TSQL script that will script out a DB and I hope I can modify that to allow me to tell it what to...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2011 at 10:29 am
That doesn't pick up the PK dependency. Not sure why.
Also, perhaps the sp_Depends bug, it doesn't pick up the view of the table is created after the view (the likely...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2011 at 8:17 am
I agree with Sumanta. You need to create a separate file group, with at least one file in it, and rebuild your clustered index for that table in the separate...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2011 at 6:19 am
I try to keep things as simpler as possible, while being descriptive, but generic. What I mean is instead of HRSelfServiceDev, I'd use HRSelfService, because it carries across environments with...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2011 at 6:14 am
I already have code that searches for the column in procs, indexes, and UDFs. My concern is for other objects, such as constraints and primary keys, or rather any other...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 20, 2011 at 6:02 am
Compression can be nice, but will vary, depending on what kind of data i stored in the DB. The question you have to answer is, why is the DB growing...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 5, 2011 at 1:06 pm
I have asked the same question myself. OK, so your DB is encrypted. What exactly does that protect you from? I suppose it protects another app, like SSMS, from some...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
April 1, 2011 at 10:45 am
Your best bet will be SQL Ping.
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 2, 2011 at 9:27 am
It depends on the traffic each will see. My data warehouse has separate files for the different data sets in one DB, because it has so much traffic that we...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 22, 2011 at 9:34 am
And in regards to the model being used, we don't have much choice here. This is used for an auditing application and management needs all data to remain in the...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 22, 2011 at 8:55 am
Viewing 15 posts - 76 through 90 (of 205 total)