Viewing 15 posts - 46 through 60 (of 196 total)
I would usually use the System Information Schema views to generate a batch of SQL to run for cases like this.
If all the...
July 31, 2018 at 7:26 am
I normally reply that I work in IT.
July 30, 2018 at 7:49 am
Yes! I agree with the previous 2 posters; Synonyms would be much better.
July 30, 2018 at 7:17 am
I would leave custom functions, stored procedures and views as they are, and instead of changing them I would create new views for each of the tables with the _mst...
July 30, 2018 at 7:09 am
I've had to use it to reset the sa password in order to gain access to the server. Previous administrator had lost the password and Built-in admins were removed at...
June 16, 2017 at 7:06 am
What does your float look like?
I normally use CONVERT to get a datetime value e.g.
SELECT
May 23, 2017 at 5:23 am
Why do you want to do this?
Does copy (from the results in SSMS) and paste (to Excel worksheet) not give you what you want?
April 11, 2017 at 8:17 am
Specifically, I changed the parameters in the data generation section to these below and then used this table to populate the original example table.
-- Set the data sample's parameters
DECLARE @SAMPLE_SIZE...
September 15, 2016 at 9:49 am
I used some of the code from Eirikur's test harness script.
September 15, 2016 at 9:23 am
Here is the UNION ALL query using a temp table so that we can have one pass at the input table as suggested by The Dixie Flatline in an earlier...
September 15, 2016 at 6:18 am
Some basic testing on my VM using the original table as posted but with 12 million rows of data has the UNION ALL query taking 6 seconds with the CROSS...
September 15, 2016 at 3:11 am
How about this.....
SELECT 'AZ' [STATE], SUM(AZ) [VAL] FROM EXAMPLE
UNION ALL
SELECT 'NY' [STATE], SUM(NY) [VAL] FROM EXAMPLE
UNION ALL
SELECT 'PA' [STATE], SUM(PA) [VAL] FROM EXAMPLE
September 14, 2016 at 9:26 am
Once upon a time this happened to me. Turned out that the update statistics job was only sampling the tables and that for the queries to run better (like...
September 7, 2016 at 8:54 am
I just moved a bunch of tables from SQL2012 to SQL2016 using the Generate Scripts option from the database context menu in Management Studio. I chose the Schema and...
September 7, 2016 at 8:50 am
Good question Steve. I guess I need to update my installation documentation from SQL 2012. It seems to be for me that I go for years without doing...
July 28, 2016 at 2:21 am
Viewing 15 posts - 46 through 60 (of 196 total)