Viewing 15 posts - 2,176 through 2,190 (of 6,041 total)
Excel is a marvelous tool for presentation and analysis, but .XLS and .XLSX are terrible formats for data interchange.
There have been cases where the business would submit excel documents...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2016 at 7:47 am
It's important that the DBA be an integral team member. Include their database development and deployment tasks as part of sprint planning and invite them to daily stand-up meetings. Invite...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2016 at 7:08 am
alex.sqldba (10/5/2016)
Yeah sadly no stored procs, otherwise it would have been much easier.
Let this archived thread be an enduring lesson to anyone currently in the process of building a database...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2016 at 6:58 am
If you are the DBA (or simply the person sitting closest to the database server), then probably the best thing you can do to improve performance is educate yourself about...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2016 at 6:53 am
sp_MsForEachDB may not be officially documented by Microsoft, but back in 2007 an anonymous member of Microsoft's SQL Server team did obliquely acknowledge it's existence.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 2:25 pm
Phil Parkin (10/4/2016)
New Born DBA (10/4/2016)
Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop down menu and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 1:24 pm
You can use a Derived Column transformation task between source and destination, or you can modify SQL to cast the column as specific data type.
For example: CAST( col1...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 12:07 pm
OK, I thought he said stored procedure earlier, so scratch that.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 11:34 am
So, you have this flat denormalized table containing nearly 100 million rows and 100+ columns. The problem is you need to report from it; performing rollups at various levels, aggregation...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 11:24 am
If for whatever reason the extended event trace doesn't give you what you need about input parameter values, then can also implement procedure call auditing using a table and adding...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 10:23 am
If I understand you correctly, you have a table containing a significant amount of history, much of which you believe can be archived elsewhere. You now want to know the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 8:03 am
Gary Varga (10/4/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 7:45 am
When in the role of a candidate, I'll typically ask why the previous person in the position decided to leave, or why he/she was let go. It's a good one...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 4, 2016 at 7:38 am
Perhaps the procedure you are executing is calling the other procedure. Look at the T-SQL contents to confirm. That would be my first guess.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 3, 2016 at 1:51 pm
Are you asking how to SQL query a text file?
If so, then you canuse OPENROWSET function.
https://msdn.microsoft.com/en-us/library/ms190312.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 3, 2016 at 1:49 pm
Viewing 15 posts - 2,176 through 2,190 (of 6,041 total)